How to import Excel file into SQL?

Question

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

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

Steve_A_Jones Grasshopper Points: 14 More actions · Answer 1

Plus there's the Import Wizard.

devilsid SSC Eights! Points: 830 More actions · Answer 2

you could use the import export data wizard on SQL server .

or if you do not have it installed ..

right click on the database>tasks>import data. follow the steps ...

or

if you have SSIS , you can use it to import data from an excel file .

or

create a table in your database and use insert command to insert the rows.

Cookies on SQLServerCentral