C# 读取CSV中数据,操作Access中数据

读取CSV中的数据到Table

            using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:csv;Extended Properties='Text;'"))

            {

                DataTable dtTable = new DataTable();

                //讀取csv檔

                OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [Test.csv]", conn);

                try

                {

                    adapter.Fill(dtTable);

                }           

            }

读取