J
Joe Fallon
Just set up a Linked ODBC table and then write a query.
You need AS400 connection software (should already be installed on your
machine.)
Then create an ODBC DSN using it and then use Access to Get External Data
and change the Files of Type to ODBC, point it at the DSN you just created
and select the tables you want to link to.
Once you have the data write queries to bring the data into Access tables.
I typcally use a MAke-Table query just once to build the initial table then
I tweak it and fix data types and add indexes,,etc.
From then on I use Apend queries.
PS - it is a bad idea to open a linked AS400 table in Access and try to
navigate around in it.
Very slow! Also, some fields do not translate well and may cause problems
with the table.
However, just avoid those fields in your queries and you should be fine. (I
think they are Packed Decimal fields - or something like that.)
You need AS400 connection software (should already be installed on your
machine.)
Then create an ODBC DSN using it and then use Access to Get External Data
and change the Files of Type to ODBC, point it at the DSN you just created
and select the tables you want to link to.
Once you have the data write queries to bring the data into Access tables.
I typcally use a MAke-Table query just once to build the initial table then
I tweak it and fix data types and add indexes,,etc.
From then on I use Apend queries.
PS - it is a bad idea to open a linked AS400 table in Access and try to
navigate around in it.
Very slow! Also, some fields do not translate well and may cause problems
with the table.
However, just avoid those fields in your queries and you should be fine. (I
think they are Packed Decimal fields - or something like that.)