import a txt file into MSAccess database and later into SQL server database using C# Code

[new2pgrmg]

Hi All, I am trying to import a txt file into MSAccess database and later into SQL server database using C# Code.This is the whole purpose. I have two questions. 1)I have a txt file that has double quotes as field separator.This text contains more than 44lakh lines with morethan 10 columns.I want to import this into an MSAccess database using C# code.I will be having a blank database already created for this purpose.We just have to import the data into this blank database using C# Code.Is it possible,if so how? 2)This is basically a continuation of the previous issue. The file that we imported into MSAccess has to be now imported into SQL server 2005 database using C# code.I tried using BCP(Bulk copy programming),but unfortunatly its not working.So that option is closed now.How can we do this using C# code?Is it possible? Many Thanks

[Spacix One]

If you must take it into access: Why not use a text editor, something like gVIM with a :%s/\"/,/g then :%s/,,/,/g command and convert it to a CVS file and do a direct import? Or you could do an indirect import by 1st going into to excel and picking " as your custom split char, but you MUST remember to import as text! Not really a reason to parse this though C# code, as you are just going to make it harder on yourself. Remember the simplest solution is most of the time the better soluiton. The only reason I could see doing this in C# is if you have to process these files many times a day or you wish to learn ADO.NET along the way. The second option doesn't seem viable if you already send Access data into SQL server, so why not modify or fork the program you have to parse the flat file directly into SQL server 2k5?

---

-Spacix All your skynet questions[^] belong to solved