Export Oracle user tables to MS Access automatically

Question

Which can be the easy way to export some user tables (DDL and data) from an Oracle database to a Microsoft Access database Automatically, it means without user interaction.

UPDATE: Linked tables on Access database raises the user/password dialog to connect oracle which is not a valid option.

Solution

You could set up linked tables in MS Access which 'point' to the actual Oracle data rather than copying it. That way the data is always up to date.

Otherwise, you will need to create a scheduled process, or maybe perform the import via VBA code each time the MS Access database is opened.

Personnally, I'd go with the linked tables.