insert into deliveries(Emailaddress,MailingName,deliverytime)
select Email,'Yikai',[Event date-time]
from OpenRowset('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\Documents and Settings\Administrator\桌面;','select * from deliveries_3.csv')
asv 跟txt 导入的格式都是一样的,请楼主参考下上面的代码