Lookup fields in AS400 to use in Access database

[splats]

Hello there

I am in need of looking up data (addresses) that is kept in an AS400 database in order to use this data in an Access 2000 database. What would be the steps that I would take in order to complete this function? I would rather not have to enter in the data that is already available as it is 1000s of records! I would not want to recreate it either as the data on the AS400 is being manipulated constantly (added to as new subdivisions are created)

Any help would be greatly appreciated!

Thank you

 

[leveyp]

No problem. You first need to add an i-Series Access( formally Clent Access) ODBC data source. Specify the AS/400 libraries which contain the files you need to read.
Then add link tables into you Acess database.