This is a PeopleSoft question, not an Access one!

By the way, I wouldn't count on PeopleSoft (or any non-Microsoft ERP,
for that matter) being able to export to .mdb. If it turns out this is
indeed the case, try exporting to a text file (preferably delimited,
although flat wil also do).

HTH,
Nikos

What database platform is PeopleSoft running on? You can
use ODBC or OLEDB to connect directly to the database.

If your 'query' is a PeopleSoft query, rather than a
passthrough query to the database platform, then you
won't be able to connect directly to it. Instead, you
would have to query the base tables, or export the
query to a text file.

If a text file is too large for Excel, you probably
won't be able to link Access directly to it.  Instead,
you would need to write code (VBA, VB, .Net or whatever)
to read the file one line at a time, and write it to
an Access table.

(david)