Extracting from Excel and Access

[Dar Scott]

On Thursday, July 24, 2003, at 10:32 AM, Mark Powell wrote:

> -2-
> Open Microsoft Access file 'foo.mdb'
> Copy Table 'blah' as text
> put it into a var

Uh.  It's been a long while...

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'.

Maybe Excel is similar.

Dar