Post reply

Importing Data

  • 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.

  • 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.

  • 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.

  • 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)

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

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