I have a CSV file here that was exported from a third party database. I need to find a way (either in C# .Net or some SQL utility) to import that CSV file into a SQL Express 2005 database. I can't export the data via SQL DUMP from the third party database and MUST use CSV.
I don't want to have to create the table in the SQL database if I don't have to so some automation would be great. So I need something that will basically do this:
1. CSV file is stored locally.
2. A table is created in SQL Server using the CSV file column headings (automatically)
3. The data is then imported into the SQL table.
It sounds fairly simple but I'm a dufus and can't figure it out. Thanks ya'll!