November 28, 2012 at 2:38 pm
Is there anyone know how to import Excel file into SQL?
Thank you
November 28, 2012 at 2:53 pm
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
November 28, 2012 at 2:54 pm
Use the data import wizard. Probably the easiest route.
Right click on database in SSMS, Tasks --> Import data. Its pretty obvious and self explanatory.
November 28, 2012 at 2:55 pm
Do you know how to do it with macro?
November 28, 2012 at 2:59 pm
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
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply