We help IT Professionals succeed at work.

Access - getting data from an Oracle database

Murray Brown
Murray Brown asked

What is the best way to automatically get data from an Oracle database on a daily basis
to be fed into Access tables.
Watch Question

Well... as Oracle exporting capabilities are not the best, and Access is not able to schedule tasks, I think that your best option is to program a script that connects to Oracle and Access databases and queries data from one to another through SQL.

Then you can programme a scheduled task to fire that script on a daily basis.

Also... as a somewhat weird alternative, SQL Server has great import/export capabilities to lots of different systems (including Oracle and, of course, Access). You could use a MSSQL Server as an intermediate pipe, and use one of it's maintenance tasks to transport data from Oracle to Access.
Murray BrownASP.net/VBA/VSTO Developer


Thanks very much