Skip to Content
0
Former Member
Jan 19, 2012 at 02:06 PM

Import data from MS ACCESS in background mode

61 Views

Hello experts,

i am facing the following problem. I´ve got to import a MS ACCESS database in background mode via job.

I got a solution which works in dialoge:

create object conn 'ADODB.Connection'.
create object rsdb 'ADODB.Recordset'.

concatenate 'Provider=Microsoft.Jet.OLEDB.4.0;'
'Data Source=C:UserspfahlbeDesktopaccess.mdb'
into sql.

call method of conn 'Open'
  exporting
  #1 = sql.

Any idea how it can be handled in background?