Excel to SQL

[Shin25]

Hi All

I have just been handed a task to export Excel workbooks with multiple sheets into sql. The excel sheet/workbook are heavily filled with data so there will be alot of data transfering.

This will happen on a regular basis...twice a month.

At the moment Iam gathering ideas how best to do this....I look forward to your ideas.....

Many Thanks

 

[abd1311]

use the import-export module in the SQL server, you can find everything there

 

[ADW]

Yeah use Import\Export. Right click on the database you want to import it into (providing you already have one) and look at the Tasks and you will find it in there...