locked
Error when running Openrowset RRS feed

  • Question

  • Hi guys,

    I'm trying to run this query on my machine remotely accessing our database using ssms. My laptop is 64 bit.

    "select * from OpenRowset('Microsoft.Jet.OLEDB.4.0','Excel 8.0; IMEX=1;Database=\\192.162.1.13\data\data.xls', 'select * from [data$]'  )"

    but I'm getting this error:

    "Msg 7399, Level 16, State 1, Line 1
    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.
    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "Microsoft.JET.OLEDB.4.0" for linked server "(null)".

    **It executed successfully when I run it on our database server.

    Database server is 32 bit. 

    Excel version I'm trying to import is 2003.

    Any ideas why I'm getting the error when I run it on my machine?

    Thank you in advance for your help!

    Thursday, June 19, 2014 12:30 AM

Answers

All replies