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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2009-09-29 : 05:59:35
|
| Hi All,INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=e:\sample.xls;','SELECT MatchID,Time FROM [Sheet1$]')SELECT top 10 MatchID,Time FROM TrendEvents Where MatchID = 6460 And SegmentID = 0GOThe above is the code to insert rows into excel using OPENROWSET.after executing the code i am getting below error.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)".How to resolve it??Solutions are easy. Understanding the problem, now, that's the hard part |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-29 : 06:09:40
|
| which is excel version you're trying to populate with? |
 |
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2009-09-29 : 06:21:49
|
| excel 2003Solutions are easy. Understanding the problem, now, that's the hard part |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
Insertiing rows in Excel