Home Forums SQL Server 2008 SQL Server 2008 - General SSIS: Importing Excel spreadsheet with more than 255 columns RE: SSIS: Importing Excel spreadsheet with more than 255 columns

  • January 31, 2011 at 5:33 pm

    #1280708

    Craig,

    I'm just using Microsoft SQL Server Management Studio to import from an .xlsx file direction. If I have the import wizard create the table, it only creates the first 255 columns, and imports them. If I first create a table in SQL Server, with the 700 columns that I need, and then try to import, it again only imports the first 255 columns, and leaves the others as NULL.