Post reply

IMPORT FROM EXCEL TO MSSQL - ERROR

  • April 18, 2009 at 12:56 am

    #129411

    PLEASE HELP ME,

    select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

    'Data Source=D:\Importingdata\Sectionsdata\Sections.xls;Extended Properties=Excel 8.0')...[Sheet1$]

    go

    IT IS GIVING ERROR

    Server: 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)".

    OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".

    🙂

  • April 18, 2009 at 3:14 am

    #980138

    hi,

    the problem was solved. i just restarted the sqlserver. before restart i have checked the configuration section ad hoc query option is enabled(but still it is giving error). When it was restarted then the problem was fixed. what is reason for this situation.

    thanks,

    🙂

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

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