EXEC master..xp_cmdshell 'bcp xybook.dbo.roy_1 in d:\DT.txt -c -Sroy -Usa -P1111'
--或 insert 表 select* from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=E:\;','select * from roy.txt')a
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) insert 表 select* from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=E:\; ', 'select * from roy.txt ')a elseselect* into 表 from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=E:\; ', 'select * from roy.txt ')a
select* into tt from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt;*.csv)}; DefaultDir=d:\; ', 'select * from stu.txt ')a执行脚本报错的: Msg 7403, Level 16, State 1, Line 1 尚未注册 OLE DB 访问接口 "MSDASQL "。
insert 表
select* from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=E:\;','select * from roy.txt')a
insert 表
select* from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=E:\; ', 'select * from roy.txt ')a
elseselect* into 表 from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=E:\; ', 'select * from roy.txt ')a
DefaultDir=d:\; ', 'select * from stu.txt ')a执行脚本报错的:
Msg 7403, Level 16, State 1, Line 1
尚未注册 OLE DB 访问接口 "MSDASQL "。