select * into linshi from OpenRowset(‘MSDASQL‘, ‘Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=F:\web\;‘,‘select sCode from 1.txt‘)
select
*
into
linshi
from
OpenRowset(
‘MSDASQL‘
,
‘Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=F:\web\;‘
‘select sCode from 1.txt‘
)
将txt文档导入数据表时
原文：http://www.cnblogs.com/VirtualLive/p/5630634.html
