Importing csv, tab delimited and excel files into c#

Question

I'm developing an Excel import routine which is using OLEDB to read the file. Can I just reuse my code to do the same thing for csv and tab delimited files by just changing the connection string, and what would the strings be?

Answer 1

I think you can, but also see this related question for: http://stackoverflow.com/questions/2312644/parsing-csv-file-in-windows-server-2008-64-c

Answer 2

Yes. See this link for the proper connection strings:

http://www.carlprothman.net/Default.aspx?tabid=81