Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Peter He Import Excel Spreadsheet to Database Tables RE: Import Excel Spreadsheet to Database Tables
Servercentral-1016448
SSC Enthusiast
Points: 166
More actions
February 17, 2010 at 12:36 am
#1119879
For import of csv files i would go for someting like this:
SELECT *
INTO tabelA
FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\Data;','select * from tabelB.csv')