Post reply

Import Excel Files

  • July 7, 2009 at 4:45 am

    #136276

    HI,

    I have a doubt regarding Importing Excel files into the SQl server database.

    I have a Excel FIle with only one sheet for example Sheet1.I used Import wizard to import the sheet1 to SQl database table.

    In the "Select Tables and views" Dialog Box - 2 sheets (sheet1 and sheet1$) are listed in the Source Column.

    The file has only one sheet but import and Export wizard displays 2 sheet name with same content.

    can anyone explain why i am getting 2 sheet names sheet1 and Sheet1

    $?

    Please pardon if my question is silly.

  • July 7, 2009 at 5:06 am

    #1020960

    generally whenever you create a excel file it gives three files.

    same whenever you try to import excel file it gives option to import all three files.

    in your case there are two sheet in your excel file so it ask to import both.

    there are also check box given to select/unselect different sheets as per your requirement.

    also left side box is for source and right side check box for destination

    u can edit sheet1$ on right side because it is table name in sql server to be imported.

  • July 7, 2009 at 8:54 pm

    #1021441

    Thanks for responding.

    I have only one sheet in my excel file Sheet1 but in import and export wizard it displays 2 Sheets - Sheet1 and Sheet1$.

  • July 8, 2009 at 12:19 am

    #1021490

    only last to lines of my post is work for you.

    first for line is general information..

    'also left side box is for source and right side check box for destination '

    sheet is showing your source(excel sheet) in left pane

    where sheet$ is showing destination table name in right pane.

  • July 14, 2009 at 9:59 am

    #1024528

    Amu (7/7/2009)

    Thanks for responding.

    I have only one sheet in my excel file Sheet1 but in import and export wizard it displays 2 Sheets - Sheet1 and Sheet1$.

    The dialog shows sheets *and* print-ranges (named ranges), so there is probably a named range defined. Depending on the version of Excel, and the menu-bar customizations, you should see a print-range box on the left and, dropping the list, you should see 'Sheet1'.

    For proof, rename the sheet to something else, and then try your import wizard again.

    Hope this helps,

    Mark

    Mark
    Just a cog in the wheel.

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

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