Yes! I do it all the time. You can import, link etc.
You must have Client Access installed on your PC, and
you need to set up a DSN(Data Source Name)
for the PF or LF(Physical/Logical File) library you are
trying to link to.
Go to Start > Settings > Control Panel
depending on your OS Go to Administrative Tools >
Data Sources (ODBC). The ODBC DSN Dialog will appear.
Click the System DSN Tab then Add.
Select Client Access ODBC Driver (32 bit), then Finish.
Click the General Tab:
Enter a name that you will remember for your DSN.
Usually I will name it the name of the AS400 Library that
the PF/LF resides in. Select the correct AS400 System from
the drop-down (Host name/IP list).
Click the Server Tab:
I usually change the name of the Default Libraries to the
library that the PF resides, just to make sure. I do the
same on the Package(s) Tab - Default Package Library.
On the Performance Tab: Select "All Libraries on the
System" from the OS400 library View drop-down.
On the "Other" Tab: I usually select Read-Only to prevent
accidentally changing data on the AS400 - this is up to
you - you may want to directly manipulate AS400 data from
Access - BE CAREFUL!
Next, click the Translate CCSID 65535.
Click OK. Close this out.
Now you're ready:
In Access add a new Link or Import table. (again your
choice) In the Files of Type select ODBC Databases.
The ODBC DSN dialog will appear again, but this time
select the DSN you just created. Another small dialog will
open listing all the PF you can link to. Select as many as
you'd like.
I would also look into Help on how to use the:
Tools > Add-ins > Linked Table Manager.
Let me know if you are still having problems.
Hope this helped. Good Luck.
jmonty
Joel Montalvo
(e-mail address removed)
-----Original Message-----
Hello,
I was wondering if it is possible to link an Access
database and pull information from an AS400 server. I know
you can generate reports and drop information into Excel
format and then import that to Access, but is it possible
to do a direct link with the AS400.
