import data into sql server from access file...

  • hi,

    actually i am fetching data from accessfile and take that into one table i am using openrowset method as below

    it's runing in my one server successfully but in another server when i am trying to execute following query it's showing me error as described below ...... can anyone help me out from this

    i am runing this query on os win server 2003 with sp1 and on sql server 2005

    on this microsoft office not installed

    and try to run same query with another server with same os version and also there is no office installed then also query run successfully but don't know why on another server it's showing me error like this

    SELECT *

    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','\\servername\testingdata\LOG.MDB';'admin';'',tablename)

    i am getting following 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)".

    Raj Acharya

  • Please don't duplicate posts. Answers here

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

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