JOIN DB2 table with Access (or other) table

[Arpeggione]

I have most of my data in DB2 tables which I am linking to. However, there are a few pieces of data I am gathering from text files. I put them into a little Access table and tried to JOIN with a DB2 table field. My query died....

Is Access amenable to joining different types of tables? If anyone can advise I would be most grateful!

Arpeggione

 

[Arpeggione]

Thank you for your reply....

your help is appreciated. In the meantime, I've decided to go another route (FOCUS) for some of this - because of the way our disparate databases are already set up.

thanks again,

Arpeggione