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 |
|
nounabarbie
Starting Member
10 Posts |
 Posted - 2006-04-13 : 07:59:16
|
| HiI used The following code to export an SQL SERVER VIEW(V1) to an excel file named testing.xlsinsert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;', 'SELECT * FROM [SheetName$]') select * from [v1](the testing.xls file contains the same header than the view) but an error occuredServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.what's wrong? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-03 : 10:44:22
|
| Make sure the file is closed before running that queryMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
failed to export