I am using SQL Server 2005 Express Edition for testing and developping my website. How can i import MS Excel Data into a SQL Server table?
The easy way?
Open your excel spreadsheet, hit control-a (Select All), control-c (Copy).
Open Management Studio, right click the table you want to "import" to, and select "Open Table". Then hit control-v (Paste).
So long as the table has the same number of columns as your spreadsheet, you're done.
|||
Thans for this solution! :) I can use that!
I also want to know what kind of other options can be used.
