Post reply

Import Export wizard

  • August 10, 2010 at 12:29 pm

    #238824

    Im using the import export wizard to create a table...it has 517 columns (long story)

    It only creates 255 columns, how can I get it to create all my columns?

  • August 10, 2010 at 1:54 pm

    #1205019

    I believe you are using Excel to import and you might be getting Truncated Text error. If yes, you may find this link useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 10, 2010 at 2:02 pm

    #1205026

    Create the table outside of the Import/Export wizard and then import the data into the already created table.

    517 columns could possibly hinder your database's performance though. Are you sure you can't normalize the data? I doubt you'll need all 517 pieces of data that frequently.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply