Link to AS400

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.
 
J

Joe Fallon

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.
 
Top