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