sql not importing excel sheet correctly - leaving off columns

246 Views Asked by At

I am trying to import a 386 x 386 matrix from excel to SQL Server. When I use the Import and Export Wizard everything seems to work correctly but when I check the created table it cuts off from column 255 onwards, i.e. I am left with 386 rows and 255 columns. Does SQL have a limit as to the number of columns imported/displayed? Thank you!

0

There are 0 best solutions below