CODEWITHSUNDEEP
sqlsql-serverexcel
raja atif
raja atif

Reputation: 188

Import data into SQL Server from an Excel file

I have an Excel (version 2007) file which has more than 700 columns and I need to import that data into my SQL Server database. When I import the data, it only imports the first 255 columns as columns in table that is created by SQL Server. I want to know how to import all 700 columns.

Upvotes: 0

Views: 177

Answers (1)

Burak Karakuş
Burak Karakuş

Reputation: 1410

You can try saving the excel data file as a text delimited file, then choose "flat file" in DTS. That should solve your problem.

Here is another solution to the problem as well: https://waheedrous.wordpress.com/2014/01/14/ssis-importing-an-excel-file-with-over-255-columns/

Upvotes: 2

Related Questions