Importing Data

• sathishkm

  SSC Veteran

  Points: 239

  More actions

  February 27, 2024 at 1:34 am

  #4385391

  Hi All,

  I have an excel data that need to to import in SQL Server. Here I have 628 columns. When I tried to import. It had imported only 255 columns, rest of the columns I am not able to import. Is there a solution?

  I have attached the sample 10 records.

  Thanks

   

   

  Attachments:

  You must be logged in to view attached files.

• Chrissy321

  SSCoach

  Points: 15790

  More actions

  February 27, 2024 at 4:58 pm

  #4385834

  I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.

• pietlinden

  SSC Guru

  Points: 63592

  More actions

  February 27, 2024 at 7:40 pm

  #4385914

  Maybe use PowerQuery to normalize? Then import the result of that? At least then you could set your source to a folder and do a folder full at once.

• Jeff Moden

  SSC Guru

  Points: 1004619

  More actions

  February 28, 2024 at 2:54 am

  #4386038

  Chrissy321 wrote:

  I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.

  Just adding my 2 cents... That would be my take on it, as well.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• jaxon. Suo

  Grasshopper

  Points: 14

  More actions

  March 1, 2024 at 2:15 am

  #4387373

  You see if this article helps you, he writes about how to export SQL Server data to Excel