Insert table via csv with non matching columns?
Posted on 2007-08-01
I am building a solution using SQL Server Express 2005. Part of this solution will be the ability to bulk upload a database table from a csv file once a day. The csv file will contain approximately 200 rows with about 50 fields in each row. The database table will contain columns that will not be present on the csv.
I am relatively new to "bulk inserts" and updating from csv/text files so could appreciate some assistance as to the best way of approaching this. I have imported from a CSV to MS Access before and could manipulate and match cvs columns to database table columns but I'm not sure as to the best way to do it in SQL 2005.
Many thanks for assistance in advance!