Post reply

load multiple excel files into a single table

  • September 9, 2014 at 11:11 am

    #310855

    I have to load multiple excel files into a single table (which has 50 columns (ntext)), but an excel file can contain any number of columns but less than 50 columns.

    Example:

    ExcelFile1: has 20 columns with 15 rows

    ExcelFile2: has 12 columns with 10 rows

    If we load above two files into a single table, the table should contain total 25 rows(first 15 rows with 20 columns and 10 rows with 12 columns)

    Thank you

  • September 9, 2014 at 11:30 am

    #1744204

    First, you made a simple statement with your post but didn't ask any question.

    Second, you posted this in another section of the forum. Do not make multiple posts for the same thing.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • September 9, 2014 at 11:35 am

    #1744207

    Closing.

    Pls post replies here: http://www.sqlservercentral.com/Forums/Topic1611892-364-1.aspx

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

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