Check out the DTS Import Wizard - see Tools menu/ Data Transformation Services, the wizard will take you through it all and supports various levels of Excel
David
May not be the most elegant solution, but why not use Database Scripting (Tools) menu - generate a script of the stored procedures and run this to install into your copy db?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.