Automatic Import from a txt file

[Birte Midjås]

Is there a possibility to automatically import directly into the access
database? Using the a commandfile in Windows for starting the import without
manually opening Access. The data will be data from an Oracle database and
the import should be done every 4 hour . Exporting from the Oracle database
is known. Or do I have to make a button in Access for importing the data. Or
can I create a macro or whatever for doing it automatically when Access is
open. That would also work.

Anybody who can help me out?

Best regards
Birte

 

[Roger Carlson]

There is a little known command line switch for access which will run a
macro. It is the /x switch. So in a scheduling program, you could put a
command like this:

c:\your\path\to\MSAccess.exe c:\the\path\to\the\database.mdb /x AnyMacro

A real example looks something like this:
C:\Program Files\Microsoft Office\Office\MSACCESS.EXE
L:\classes\cis253\Cis253\Library97\RemoteMacro.mdb /xAutoRun


On my website (see sig below) called "RunRemoteMacro.mdb" (it is in the
Access 97 library, but will work with any version), that illustrates how
this works.

 

[Joe Fallon]

You can link directly to Oracle and import data.
No need for text files.