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 |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2011-06-17 : 09:58:54
|
| Has anyone managed to get openrowset working on a 64bit server with 64bit Sql Server 2008 R2?I've tried everything, downloading the 64bit drivers from MS, enabling Ad Hoc queries etc but still get the following error:OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".My query is as follows:insert into OPENROWSET('Microsoft.Ace.OLEDB.12.0', 'Excel 12.0;HDR=YES;Database="&server.MapPath("/users/documents/"&filename&".xls")&";', 'SELECT * FROM [Sheet1$]') select field1, field2 from whatever....It used to work on a 32bit server using the Jet oledb.4 driver, but we've bought a new one and I cant get anything at all working with openrowset now... |
|
|
|
|
|
Microsoft.ACE.OLEDB.12 on 64bit server