What's the best way to transfer data from Excel to SQL Server?
I have the SQL server table set up and the spreadsheet is set up like the
table with field names in the first row and data below. There are over
3000
rows and the number of rows could vary each month when the process is run.
Should I loop through each row and execute a SQL INSERT statement (using
ADO) for each row?
Should I add all 3000 rows to a recordset and then use the Update method
of
the recordset?
Or is there some other method that's better for moving the data?
--
"Just because you don''t know how to do something doesn''t mean it can''t
be
done"
Billy Rogers
Currently Using SQL Server 2000, Office 2000 and Office 2003
http://thedataguru.blogspot.com/
