Post reply

Import from Excel

  • October 24, 2006 at 2:26 pm

    #113982

    I have a stored procedure which imports data from excel. I was working fine till recently and start failing now.

    SELECT

    *

    FROM

    OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=\\myserver\e$\Source\Exceltest.xls;Extended Properties=Excel 8.0')...[sheet1$]

    it is giving error:

    OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified 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)".

     

    I tried to connect to local machine and it worked fine. So it seems some setting on the server which is messed up. Did any body had the same issue.

    PS: I am using SQL Server 2005 without SP1 on windows 2003.

  • October 25, 2006 at 1:29 pm

    #667987

    Check and see if the Excell sheet is named something other than Sheet1

  • October 25, 2006 at 2:52 pm

    #668011

    I checked and its Sheet1. Also I used the some old file for Archive folder which did worked earlier ( about month back).

    Any more suggestions.

     

  • October 26, 2006 at 7:53 am

    #668181

    Map data source as a local hard drive. Change Data Source to be the new one.

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

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