Writing to a MS Access table through Oracle SQL script

[senamuna]

I am generating reports off an Oracle 9i database of an warehousing application. I have only read rights. The database only records the last status of an order and the date/time last modified. I need to store a snapshot of order status when the shift changes, so that I can use that data to produce production statistics.

I want to write to an MS Access database in the local machine from the Oracle SQL script I run in Crystal Reports command line. Running the report at the necessary time is possible.

Any advise and/or sample code is much appreciated.

 

[synapsevampire]

Crystal Reports doesn't have a command line, do you mean the command object?

You probably want a scheduled event in MS Access to do all of this, Crystal isn't the correct tool for writing to Access tables.

Check with the fine folks in the Access forums.

-k