Export linked tables statically (no password prompt)

[DaveC]

I have a set of tables in an Oracle 9.2 instance that I need to transfer to an Access database. The Oracle server is being shut down and I need to save the data for archival purposes.



I have been using Access as the front end for queries and reports, with the Oracle tables linked via ODBC. If I try to export from that MDB the link gets copied too, requiring user name and password to get to Oracle. I need a way to capture the schema and data from a dozen tables as a snapshot of the current contents independent of Oracle, since the original will no longer exist.

Can this be done?

Thanks.

Dave C

[ranman256]

Just create a MAKE TABLE query. It will copy the data to an access table.

[DaveC]

Excellent. Thank you.

[DaveC]

BTW, is there a physical limit to the size of an Access table? One of the Oracle tables I'm trying to export has about 15 million records.