Transfer data from AS/400 to Access Table

[SteveGr]

Hi all,

Does anyone know if there is a way to transfer data from an AS/400 Mainframe to a Access table?

I currently transfer it into an Excel spreadsheet and then link to that. Which is OK, but I am wondering if I can cut out the middleman.

Thanks, Stevegr

 

[FloBob]

Yah thats really easy how do you get it into excel a datasource?... Thats all we do here mostly we attach to queries but tables are also easy. Just go to file get external data, import or link. Then select odbc datasource in your file type box that comes up... Look for it its at the bottom. Youll have to know which connection you use for excel but just follow the same path and you should be able to connect straight to it. Hope this helps