select * from
opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source=F:\工商程序\工商\年检数据.XLS;Extended Properties=Excel 8.0')...[年检数据$]你有用其他东西打开这个文件吗?
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=NO;DATABASE=d:\book1.xls',sheet1$)试试
opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source=F:\工商程序\工商\年检数据.XLS;Extended Properties=Excel 8.0')...[年检数据$]你有用其他东西打开这个文件吗?
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=NO;DATABASE=d:\book1.xls',sheet1$)试试
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions改为5.0呢?
SELECT * FROM OPENROWSET('MSDASQL.1', 'driver=Microsoft Excel Driver (*.xls);DBQ=D:\Daliasss.XLS','select * from iostor')这个就不行:
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions第二种方法我有测试过是可以,不过从昨天开始就一直出问题,能不能说明是什么问题?是不是驱动有问题??谢谢大力哦
SELECT * FROM OPENROWSET('MSDASQL.1', 'driver=Microsoft Excel Driver (*.xls);DBQ=D:\Daliasss.XLS','select * from iostor')