var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: export data from excel 2007 to MS SQL server 2008?
Anyone know how to export data from excel 2007 to MS SQL server 2008?
I have four thousand rows of data, I wonder if I can put in all the data without copying and pasting so many time. Please let me know. Thank you.
One (easy) way is using SQL Server Integration Services, or you may have a look at the following link: bulk insert
Thanks for the link. I will look into it.
I tried using this, but got some red stuff near the file address C:\ . Anyone know why?
How to import data from Excel to SQL Server
Use a Linked Server:
SELECT * INTO Dates FROM C:\Documents and Settings\bt\Desktop\Optimum_west_join_tables.xls[Dates]