Apache OpenOffice Community Forum

I was wondering if anyone knows of a way to program a macro to disconnect a data source.

The reason I ask is that I am currently running a separate application which exports the data for a merge in a text file. The problem is that there are multiple times a day that a merge needs to be run, however after the first time the data file is accessed by OO it is locked until the data source is disconnected.

I appreciate any help.

The oooforum gave this result: http://www.oooforum.org/forum/viewtopic.phtml?t=10399

connection.close() does the trick.