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 |
|
rum23
Yak Posting Veteran
77 Posts |
 Posted - 2009-04-01 : 12:43:20
|
| Can somebody please tell me what is wrong with this SQL? Thanks a tonSELECT ProjectName INTO tblTestFROM OpenRowSet('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\junk\testing.xls', 'SELECT ProjectName FROM [Sheet1$]')I get the following error when trying to execute...Msg 7399, Level 16, State 1, Line 1The 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.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-01 : 13:20:47
|
| http://support.microsoft.com/kb/321686 |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
openrowset