Import data from excel into SQL table 1

[munchen]

I have created a blank db table in Microsoft SQL Management Studio 2005 and I have all the data in an excel file (Excel 2007).

Is there a simple way to import the data from excel into my newly created table?

Can I do an insert into?

 

[markros]

Try using Import/Export Wizard from SSMS. Right click on the database, Tasks, Import...

 

[markros]

See also

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12

PluralSight Learning Library

 

[NoCoolHandle]

You might also want to do a search on BOL for sp_addLinkedServer.

You can use this to run a SQL query against a named range or spreadsheet. (order by, sum(),select etc....)

All the code you need to connect directly to an excel workbook is shown in the examples.

For what it is worth.


Rob

 

[mahendrahegde]

Munchen,
If the datatypes are same in SQL server and excel, just COPY-PASTE required data from excel to sql server table.
(copy from excel by selection and paste by ctrl+v in opened table in Sql server)

Mahendra Hegde