Extracting from Excel and Access

[Dar Scott]

On Thursday, July 24, 2003, at 10:47 AM, Dar Scott wrote:

> Maybe you can set up a VBA function in the Access file to run when it 
> is opened.  It can check the command switch in the command line for a 
> keyword you make up plus 'blah'.  It then exports the table.
>
> In Rev you run a script that uses shell to run access with the cmd 
> switch and then 'put URL'.

Or maybe there is a way to use the macro switch.  You might also need 
to set some switches to force access to skip dialogs and maybe other 
windows.

Dar