data provider or other service returned an e_fail status (1 Viewer)

P

paulcherianc

Registered User.

Local time

Today, 11:10

Joined

Aug 15, 2013

Messages

86

• Jun 23, 2016

• #1

I am trying to pull a query from access to excel and got an error message as attached saying "data provider or other service returned an e_fail status"

Any Experts!!:banghead:

 

Attachments

• 
  Capture.JPG

  78.9 KB · Views: 300

J

JHB

Have been here a while

Local time

Today, 20:10

Joined

Jun 17, 2012

Messages

7,732

• Jun 23, 2016

• #2

I don't like the space in the database name, try to rename it.

 

P

paulcherianc

Registered User.

Local time

Today, 11:10

Joined

Aug 15, 2013

Messages

86

• Jun 23, 2016

• #3

Tried but no hope! Same error!

 

J

JHB

Have been here a while

Local time

Today, 20:10

Joined

Jun 17, 2012

Messages

7,732

• Jun 23, 2016

• #4

Okay - in which line do you get the error?

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 02:10

Joined

May 7, 2009

Messages

19,230

• Jun 23, 2016

• #5

you have a space in your database name you must enclosed the whole path in bracket:

[C:\users\pcherian\Desktop\HRProRev 29.accdb]

why don't you use DAO instead, its much simpler.

Dim db as dao.database
dim rs As dao.recordset
dim sQry as string

sQry = "SELECT * FROM Final_Export_3 IN '[C:\users\pcherian\Desktop\HRProRev 29.accdb]';"
rs = db.Openrecordset(sQry, dbOpensnapshot)
' do the import in excel here
'...
'...
rs.close
set rs=nothing
set db=nothing