Home Forums SQL Server 2008 SQL Server 2008 - General Importing and Splitting 150,000 columns flat file into three tables of 50,000 cloumns each RE: Importing and Splitting 150,000 columns flat file into three tables of 50,000 cloumns each

  • September 18, 2012 at 12:48 pm

    #1539238

    just to pile on the bad news; Excel 2010 is limited to a max of 16384 columns.

    so you need a few more(10+?) worksheets or so.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!