Link to AS400

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

Lee T.

I tried the "docmd.TransferDatabase acImport" method to
get data from the ISeries (AS/400) but I have not been
successful. I was wondering if any one has had experience
with connecting to the 400 this way and could share how
they did it.

TIA

LT.
 
Sure.
Many years ago.
It is "just another ODBC data source."

So you need an ODBC driver and connection first.
Then in Access you use the ODBC DSN and link to the tables.
Then write queries against the linked tables.
 
Back
Top