This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Importing CSV

Question
0

Sign in to vote

I am trying to import CSV files using SQL Server import and export wizard but I can't find a data source that will allow me to import them, when I try importing them using Mircosoft Excel as the data source is says the file must be in .xls formt

Thursday, May 28, 2009 5:32 PM

Answers

1

Sign in to vote
What's the SQL Server version that you are using? If using SQL Server 2005 or 2008 look at this link - http://www.sql-server-performance.com/articles/biz/How_to_Import_a_Comma_Separated_File_into_SQL_Server_2008_p1.aspx

For datasource try using Flat File Source and see if it works. You can also use BULK INSERT to import csv file to SQL Server - http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

Hope this helps
This posting is provided "AS IS" with no warranties, and confers no rights
- Marked as answer by John C GordonMicrosoft employee Friday, May 29, 2009 4:31 AM
Thursday, May 28, 2009 6:57 PM