【笔记】CSV文件导入数据库SQL脚本

Posted on 2009-11-13 11:29 AndyZhou 阅读(577) 评论(0) 编辑收藏举报

Insert into alarm.allip (alarm_id,alarm_class,alarm_category,alarm_mo,alarm_time,alarm_text,bsc_id,scan_time)
select alarm_id, alarm_class,alarm_category,alarm_mo,alarm_time,alarm_text,bsc_id,scan_time
from OpenDataSource('MICROSOFT.JET.OLEDB.4.0','Text;HDR=Yes;DATABASE=D:\North\')...[text2#csv]