import data into sql server from access file using openrowset function

• raj acharya

  SSCrazy

  Points: 2805

  More actions

  January 23, 2009 at 4:31 am

  #126939

  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

• Jack Corbett

  SSC Guru

  Points: 184388

  More actions

  January 23, 2009 at 8:45 am

  #931829

  Check out this link: http://support.microsoft.com/kb/814398

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question