none
Quering excel

    Question

  • Hi there,

     

    I have 2 servers, on server A the query:

     

    SELECT * --INTO #productlist

    FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

        'Excel 8.0;HDR=YES;Database=C:\Book1.xls',

        'SELECT * FROM [Sheet1$]');

     

     

    Run perfectlly, but on server B i get the error:

     

    OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$' is not a local object, check your network connection or contact the server administrator.".

    Msg 7350, Level 16, State 2, Line 1

    Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

    If i go to Proviver -> Microsoft.ACE.OLEDB.12.0 -> Properties:
    On the server that works: on the white square bellow i got: Linked servers using this provider: XML
    On the server with error i got nothing.
    Can someone help me?

    ------------------------------------------------------------- Oracle OCA11g
    Monday, April 4, 2011 4:48 PM

Answers

All replies