Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
barak.karni
Starting Member
4 Posts |
 Posted - 2010-08-10 : 03:16:08
|
| hi all,i have a newly incountered problem. i am using a OperRowSet function to read a table from a remote server. yet i keep getting an error message:The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.the code is:select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=c:\tester.xls', 'Select * from [1$]')where c:\tester is the file, and 1$ is the sheet.any help will be greatly appreciated. |
|
|
barak.karni
Starting Member
4 Posts |
Posted - 2010-08-10 : 03:22:20
|
| another note i thopught about but have no idea if it's true...what if it's not excel 8.0... what eles can it be? .xls file |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-10 : 03:53:33
|
| Note that the file should be in Server's directoryMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Load tables from excel