用 SQL 脚本将 CSV 导入 MSSQL

1 INSERT INTO TC_Contacts
2
3 SELECT * FROM
4  OPENROWSET('MSDASQL',
5  'Driver={Microsoft Text Driver (*.txt; *.csv)};
6    DEFAULTDIR=D:\Data;Extensions=CSV;',
7  'SELECT * FROM "Contacts.CSV"')