如何用C#编程实现将有分隔符的CSV数据文件导入到access数据库文件中去

来源:百度知道 编辑:UC知道 时间:2024/05/28 04:09:47
把csv格式的数据文件,导入到数据库中,找点资料,最好有源码的列子,急需!!!

objStreamReader = new StreamReader(strPath, System.Text.Encoding.Unicode);
while (objStreamReader.Peek() >= 0)
{
string strLine = objStreamReader.ReadLine();
string[] splitData = strLine.Split(',');
Service clsService = new Service();
//clsService.ID = splitData[0];
clsService.Date = splitData[1];
clsService.Subject = splitData[2];
clsService.CustomerNM = splitData[3];
clsService.Birthday = splitData[4];
clsService.Commodity = splitData[5];
clsService.Address = splitData[6];
clsService.Identity = splitData[7];
clsService.Money = splitData[8];
clsService