CREATE TABLE [dbo].[Table_1](
[Y1] [char](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[M1] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[D1] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
insert into Table_1(Y1,M1,D1)
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;HDR=YES;IMEX=0;DATABASE=C:\a.xls','select Year(F6),Month(F6),Day(F6) from [a, Payroll Report$] where F6 is not null')
Select * from Table_1
提示错误:
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Data type mismatch in criteria expression.".
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Data type mismatch in criteria expression.".
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Data type mismatch in criteria expression.".
Msg 7346, Level 16, State 2, Line 10
Cannot get the data of the row from the OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)". The provider cannot determine the value for this column.
[Y1] [char](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[M1] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[D1] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
insert into Table_1(Y1,M1,D1)
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 8.0;HDR=YES;IMEX=0;DATABASE=C:\a.xls','select Year(F6),Month(F6),Day(F6) from [a, Payroll Report$] where F6 is not null')
Select * from Table_1
提示错误:
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Data type mismatch in criteria expression.".
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Data type mismatch in criteria expression.".
OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Data type mismatch in criteria expression.".
Msg 7346, Level 16, State 2, Line 10
Cannot get the data of the row from the OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)". The provider cannot determine the value for this column.
解决方案 »
- col1省份代码 col2客户代码 想把两列合并作为col3 update 湖北 set col3=col1||col2 怎么结果变成了'col1||col2'
- 求高手们!!!我怎么用SSIS 把sql2005的库(全部表;结构,索引,数据)整个导到 oracle.反之怎么从oracle--》sql2005
- 请各位看一下这个sum语法对不对?
- 用查詢語句實現流水號字段,如何做
- 如何用一个备份文件恢复生成四个不同名的数据库(结构完全一样)谢谢!(在线等待)
- 关于WITH AS
- sql中如何加记录
- sql中替换多个特殊字符
- 关于Delphi 5.0 对SQL Server 中的 Money 类型字段的疑问?????
- 怎样列出所有本地SQL SERVER中的数据库?
- 数据库优化和维护
- 求一条存储过程的写法
不再本地的不可以
都安装了Office2003(同一张盘)除了我自己机器以外的机器都提示以上错误
我没有建立linkserver,通过运行
sp_configure 'Ad Hoc Distributed Queries',1
reconfigure with override
go
开放Distributed Queries的权限。The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Sheet1$". The table either does not exist
or the current user does not have permissions on that table.================================================
Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB;Data Source=dsname;" & _
"Initial Catalog=master;User ID=sa;Password=admin"'Import by using OPENDATASOURCE.strSQL = "insert into table1 (column1,column2) " & _
"select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _
"'Data Source=psFilename;" & _
"Extended Properties=Excel 8.0')...[Sheet1$]"'Debug.Print strSQL
cn.Execute strSQL, lngRecsAff, adExecuteNoRecords