import .csv file into SQL Server via asp.net page

[Andrew J Gray]

Guys
Anyone know of a component or code example to enable the import of a .csv
file (typically exported from Outlook contacts) into SQL Server through an
asp.net UI?

The holy grail would actually be a total solution enabling a sync of Outlook
Contact data to a SQL Server table via an asp.net page.

regards
Andy

 

[Teemu Keiski]

Generally you can read it into DataSet using OleDb (Jet provider can open
CSV files, it treats them bit similarly to Excel spreadsheets). After you
get it to DataSet, you can do whatever you want with it.