Linked Server for Excel File

  • We are using 32 bit SQL 2K5 (Enterprise Edition) in clustered environment. For almost 1 year we are using linked server for Excel file and is working fine. Suddenly from last 2-3 days, it started giving error now even with openrowset we are not able to query Excel files.

    SQL Service is having Admin privileges on the physical machine and we have tried creating linked server for files kept on local drives also but it is giving following error.

    Msg 7399, Level 16, State 1, Line 1

    The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EXT" reported an error. The provider ran out of memory.

    Msg 7320, Level 16, State 2, Line 1

    Cannot execute the query "select * from [upload$]" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EXT".

    Can anyone help in this..

  • Try to check the page file settings ---- are they optimally set???

    max & min memory of SQL Server.

    Check the excel file if the file has some bulky data\ problem is with some specific file....... check with a simple 10rows excel file.

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

  • Thanks for your reply. But we have tried with an excel file containing less than 100 records.

    Also memory allocated to the instance is 8 GB.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply