txt导入到access数据库（txt2access）

txt2access1

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;

namespace txttoaccess1
{
    public partial class Form1 : Form
    {
        public Form1（）
        {
            InitializeComponent（）;
        }

        string str_FilePath = “D:\\2.txt“;
        //string str_DaraSource = “D:\\test.accdb“;
        String str_FolderPath = “D:\\text“;

        private void button1_Click（object sender EventArgs e）
        {
            string P_Connection = string.Format（//创建数据库连接字符串
                //“Provider=Microsoft.jet.OLEDB.4.0;Data Source=test.mdb;User Id=Admin“）;
                  “Provider=Micro

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2014-09-17 08:12  txttoaccess1\
     目录           0  2014-09-17 08:12  txttoaccess1\txttoaccess1\
     文件        9462  2014-09-18 19:11  txttoaccess1\txttoaccess1\Form1.Designer.cs
     文件        9627  2014-09-18 19:11  txttoaccess1\txttoaccess1\Form1.cs
     文件        5817  2014-09-18 19:11  txttoaccess1\txttoaccess1\Form1.resx
     文件         493  2014-09-17 08:11  txttoaccess1\txttoaccess1\Program.cs
     目录           0  2014-09-17 08:11  txttoaccess1\txttoaccess1\Properties\
     文件        1356  2014-09-17 08:11  txttoaccess1\txttoaccess1\Properties\AssemblyInfo.cs
     文件        2872  2014-09-17 08:11  txttoaccess1\txttoaccess1\Properties\Resources.Designer.cs
     文件        5612  2014-09-17 08:11  txttoaccess1\txttoaccess1\Properties\Resources.resx
     文件        1095  2014-09-17 08:11  txttoaccess1\txttoaccess1\Properties\Settings.Designer.cs
     文件         249  2014-09-17 08:11  txttoaccess1\txttoaccess1\Properties\Settings.settings
     目录           0  2014-09-17 08:11  txttoaccess1\txttoaccess1\bin\
     目录           0  2014-10-27 18:09  txttoaccess1\txttoaccess1\bin\Debug\
     文件      847872  2014-10-27 18:09  txttoaccess1\txttoaccess1\bin\Debug\test.accdb
     文件      356352  2014-10-27 18:09  txttoaccess1\txttoaccess1\bin\Debug\test.mdb
     文件       14848  2014-09-18 19:11  txttoaccess1\txttoaccess1\bin\Debug\txttoaccess1.exe
     文件       30208  2014-09-18 19:11  txttoaccess1\txttoaccess1\bin\Debug\txttoaccess1.pdb
     文件       11600  2014-10-27 18:00  txttoaccess1\txttoaccess1\bin\Debug\txttoaccess1.vshost.exe
     文件         490  2010-03-17 22:39  txttoaccess1\txttoaccess1\bin\Debug\txttoaccess1.vshost.exe.manifest
     目录           0  2014-09-17 08:11  txttoaccess1\txttoaccess1\obj\
     目录           0  2014-09-17 08:11  txttoaccess1\txttoaccess1\obj\x86\
     目录           0  2014-09-18 19:11  txttoaccess1\txttoaccess1\obj\x86\Debug\
     文件        4440  2014-09-17 09:30  txttoaccess1\txttoaccess1\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
     文件        6332  2014-09-18 19:11  txttoaccess1\txttoaccess1\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
     文件         396  2014-09-18 19:11  txttoaccess1\txttoaccess1\obj\x86\Debug\GenerateResource.read.1.tlog
     文件         910  2014-09-18 19:11  txttoaccess1\txttoaccess1\obj\x86\Debug\GenerateResource.write.1.tlog
     文件        7897  2014-09-17 09:32  txttoaccess1\txttoaccess1\obj\x86\Debug\ResolveAssemblyReference.cache
     目录           0  2014-10-27 18:09  txttoaccess1\txttoaccess1\obj\x86\Debug\TempPE\
     文件         180  2014-09-18 19:11  txttoaccess1\txttoaccess1\obj\x86\Debug\txttoaccess1.Form1.resources
     文件         180  2014-09-17 08:22  txttoaccess1\txttoaccess1\obj\x86\Debug\txttoaccess1.Properties.Resources.resources
............此处省略6个文件信息