"a ", "b ", "c ", "d ", "e " 00001, 7398,MICROSOFT PRESS SPECIAL,49.99, 0-7356-0652-8 00002, 7832, MICROSOFT - WWF , 45.63, 0-4562-0582-5 00003, 5643, MICROSOFT - WWF , 21.5 , 0-5545-0457-7 用SELECT * FROM OPENROWSET('MSDASQL.1','Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=e:\','select * from a.txt') 导入到sql
EXEC master..xp_cmdshell 'bcp "dbname..tablename" in c:\DT.txt -c -Sservername -Usa -Ppassword'
to pengdali(大力 V2.0) 服务器: 消息 7399,级别 16,状态 1,行 1 OLE DB 提供程序 'MSDASQL.1' 报错。提供程序未给出有关错误的任何信息。 OLE DB 错误跟踪[OLE/DB Provider 'MSDASQL.1' IDBInitialize::Initialize returned 0x80004005: 提供程序未给出有关错误的任何信息。]。
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
NULL
开始复制...
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
NULL
BCP 复制 in 失败
NULL
00001, 7398,MICROSOFT PRESS SPECIAL,49.99, 0-7356-0652-8
00002, 7832, MICROSOFT - WWF , 45.63, 0-4562-0582-5
00003, 5643, MICROSOFT - WWF , 21.5 , 0-5545-0457-7
用SELECT * FROM OPENROWSET('MSDASQL.1','Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=e:\','select * from a.txt') 导入到sql
OLE DB 提供程序 'MSDASQL.1' 报错。提供程序未给出有关错误的任何信息。
OLE DB 错误跟踪[OLE/DB Provider 'MSDASQL.1' IDBInitialize::Initialize returned 0x80004005: 提供程序未给出有关错误的任何信息。]。