Friday, March 9, 2012

How can I import data from Excel to SQL server 2005 Express

I would like to import an Excel file into my SQL Server 2005 Express db. I'm using SQL Server Management Studio Express to manage my db.

I appreciate your suggestions,

You need to use SQL server Business Intelligence Development studio and create SSIS package

Using simple Drag and Drop controls

|||

Sorry, I do not have these tools to work with.

|||

Ok, Right click on the Database then Task -> Import

select your Data source as Microsoft Excel file map the fields to destination click finish

No comments:

Post a Comment