PeopleSoft Query downloaded to Access instead of Excel

[Emeryboard32]

I have over 500,000 lines of information from a PeopleSoft query and Excel
will not hold that much information. I need to download my query information
to Access instead. Can you tell me how to do this

 

[Nikos Yannacopoulos]

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

 

[david epsom dot com dot au]

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)