paulcherianc
Registered User.
- Local time
- Yesterday, 23:06
- Joined
- Aug 15, 2013
- Messages
- 86
data provider or other service returned an e_fail status
- Thread starter paulcherianc
- Start date
paulcherianc
Registered User.
- Local time
- Yesterday, 23:06
- Joined
- Aug 15, 2013
- Messages
- 86
Tried but no hope! Same error!
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 15:06
- Joined
- May 7, 2009
- Messages
- 19,836
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
[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
