I've been downloading a file from an AS400 directly into Excel using the iSeries add-in. I now want to do the same thing into an Access table through VBA. I connect to the AS400 without an error but I don't know how to download/query the data. If it were a PC file system I would say the file is MyAS400\COMMON\RCOB00P1\MyUserID. The .dtf file for the Excel download uses:
[HostInfo]
HostName=MyAS400
HostFile=COMMON/RCOB001P(MyUserID)

Some of the files are exceeding 64k and I would prefer to not download a .csv file and then import it if I can go directly to the table.

what I did I created a OBDC connection to the AS400 from MSaccess97 then you see the data live

myle,

Do you know from where to get an ODBC driver for AS/400? With the aim of
helping cprouse, I looked in the CDs of several versions of MS Office and performed a Google search but I was not able to locate a free one. The few links I got back from Google were broken.