Connect to data on a AS400

S

Steve D

Cathy:

Have you considered running a query and FTP the data to
the PC or a shared folder on the AS/400?

Steve D
 
J

Joe Fallon

You need an ODBC driver.
Your PC should have an AS400 client program on it that has such a driver.

Then set up an ODBC system DSN using your driver and credentials.
Then File, Get External Data, Link
Change Files of type to ODBC
Pick your system DSN
Log in
Check Save Password
Select some tables
Be sure to select Unique Record Identifier(s) if asked.

Write a query against the linked table.
 

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
ODBC link to AS400 in Access 2007 2
split data base using ODBC connection 1
Importing an AS400 table 1
odbc 1
ODBC Link error too many indexes with AS400 4
Beginner: How do I link via ODBC from a PC into an AS400? 7
Update a file on AS400 0

Top