Post reply

Linked Server problems

  • February 7, 2008 at 8:37 am

    #71309

    Is there a maximum size for an Excel spreadsheet when using a linked server on SQL Server 2005?

    I have a spreadsheet that has 3 Sheets. The first two have the maximum number of rows, the last does not.

    I have created a linked server using the Jet 4.0 OLE DB Provider.

    If I use a smaller spreadsheet and run the following query:

    SELECT * INTO EQUIPMENT FROM RMSDATALOAD...Sheet1$

    The table gets created and the data is loaded correctly.

    When I use my mega spreadsheet I get the error:

    Msg 7399, Level 16, State 1, Line 1

    The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "RMSDATALOAD" 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 "RMSDATALOAD".

    Anybody have any ideas?

  • February 7, 2008 at 9:00 am

    #776063

    I am sure you found this, but wanted to point it out anyway:

    http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

    states:

    It should be noted that the Excel file must be located in the SQL Server where you are connected and not on your local machine. The C: drive specified in the OPENROWSET function is the C: drive of the SQL Server you are connected to and not your local C: drive. If the Excel file specified in the provider_string parameter of the OPENROWSET function does not exist or is incorrect, the following error will be encountered:

    Server: Msg 7399, Level 16, State 1, Line 1

    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

    The provider did not give any information about the error.

    OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'

    IDBInitialize::Initialize returned 0x80004005:

    The provider did not give any information about the error.].

    -- Cory

  • February 7, 2008 at 9:09 am

    #776068

    Cory,

    Thanks for the reply, but as I have said. It already works with a smaller spreadsheet and yes the spreadsheet is on the server, not on my local drive.

    With a smaller spreadsheet everything is ok. It is when I attempt with a large spreadsheet that I get the problem.

    Regards

    Jon L.

  • February 7, 2008 at 9:48 am

    #776080

    Okay - next thing I found was this:

    http://support.microsoft.com/kb/201905

    if these were tested, perhaps it would be better to tell us whatelse you have tried.

    -- Cory

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

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