How to create an SQL table and and populate it with Excel spreadsheet data?
dts, excel, sql-server, ssis
Solution
If the data is not that big and if it is a simple table, easiest way is to create and open the table in SQL Server Management Studio and copy paste the excel data into it.
Other solutions are using DTS or using SSIS..
Problem
Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool? Thanks in advance.