Hi There,
I have a requirement to import a large number of csv files to one table. The files are in the format NAME.date.csv. What is the best way to do this?
Cheers
Pete
There are several options, bcp, dts or bulk insert.
Depending on how much logic should be applied in the import you may want to use dts or bulk insert.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
No comments:
Post a Comment