This project is read-only.


How do I inject the excel data


I have successfully installed the AdventureWorks DB. Now I need to inject some data into the DB. Is there a script that I can run that injects all the nice data from all those excel files?
Closed Aug 12, 2008 at 10:10 PM by ReedMe
Your best bet is to create an Integration Services (SSIS) package for loading Excel data. Or use an Excel forumla to add a column which creates INSERT statements from your data, and copy-n-paste those INSERT statements into Management Studio.