How to import Excel file into SQL?

  • Is there anyone know how to import Excel file into SQL?

    Thank you

  • have you looked into the built in Import Export Wizard, or SSIS or using a linked Server yet?

    one of the many selections of the wizard is to chose an excel spreadsheet. (in Object Explorer, right click on the database...Tasks...Import Data)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Use the data import wizard. Probably the easiest route.

    Right click on database in SSMS, Tasks --> Import data. Its pretty obvious and self explanatory.

  • Do you know how to do it with macro?

  • tantcu (11/28/2012)


    Do you know how to do it with macro?

    any macro is going to have too many specifics...you have to build the macro before you can use it, and that means you need to know the programming syntax, the name of the server, all the connection information, and the destination table name.

    If your not a programmer, stick with the wizard we mentioned.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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