When importing an .xlsx file the number of columns stops at 255. Does anybody know howto get all columns imported?

Triedsaving the file as text and that allows me to import all the columnsbut it wouldbe much easier to do this directly from Excel.

Thanks

What tools and techniques are you using to import the XSLX file now? As in, what connection manager, data source component and so on.

Does this help at all? http://bi-polar23.blogspot.com/2007/08/but-what-about-excel-2007.html

I am importing currently with SQL.

I choose Microsoft Office 12 Access Database connector

Change the extended properties to Excel 12.0.

It connects and imports with no issues but it always cuts off the columns at 255. The file I need to import has about 2x as many columns.

Thanks

Can you try this?

First import it into a .csv text file. Rename the .csv file. Import it to the database from the .csv file.

I have tried to save as CSV. I get all the columns but because a lot of the columns are a mixture of numerical and text values it fails because it is expecting a text value and a number is in the column.

With Excel I have made them all textcolumns.

I have imported the file in two pieces and I will combine the two. Seems the quickest solution for now.

Still would love to import a file directly from Excel 2007 into SQL without going through all this extra work.

Thanks

So are you using SSIS at all? If not, did you look at the link I posted earlier?