SQL Server 2005: Importing data from Excel- First the hard way then the easy way.
<p> If you find yourself needing to convert data from Excel to SQL Server then this session is for you. I used to use the import wizard to import worksheets of data from Excel to SQL Server...I used to think it was the coolest thing...but not anymore. </p> <p> It was taking me a long time to define the source data, then the destination, then the mapping...lots of clicking- click, click, click. </p> <p> Then I came across this "secret" script that grabs the data that I want from a specific worksheet in Excel. I don't have to click, click, click anymore.</p> <p> - Please feel free to edit</p> <p> </p> <p> Cheers,</p> <p> allan</p>
allan rubio
SQL Server | Import Data
Mobile Home
Sessions
Schedule
Presenters
Rooms
Login