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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AS400 connection problems 2
Shared Link is showing empty notebook 1
ODBC link to AS400 in Access 2007 2
Link to ODBC source with different DSN names 0
Linked Table to AS/400 Member within a File 1
I have lost 6 months work, how can i get my file back 1
How to paste this down? 3
Importing FoxPro 2.6 DBF Into Access 2007 1

Top