Day 3 - Data from Excel to DB - SSIS

1pm

While Michael made his forms app, I used SQL 2005 Integration Services. Used my datasource as Excel, and my destination db. Only trick was to remember to set the destination table name, and to map the columns correctly.


Don't know if this is available for SQL 2005 Express users.. to get there from SQL 2005, right click on the database, and tasks export data.