Hi Juraj,

One solution may be would to write a macro which opens a Calc document with a data range connected to your database and export it to dbase after a refresh.
I'm not familiar with the Calc API but it should be possible.

Best regards,

Ocke

Juraj Trenkler wrote:
St 30. August 2006 16:49 Andrew Jensen wrote/napisal:
When you do this export are you creating six new files ( could also mean
purging and populating only with exported data ) or are you updating
exisiting records and inserting new ones?

In my part of project I want to use OOo as frontend to fill patient and samples data from my department. I will use embedded HSQLDB or MySQL server. At the end of the month I have to send our data to manager of hospital project to further processing. As he uses program build by FoxPro2.6 for DOS, the data have to be in dbf format. So my problem is to make some querries and transform their results to dbf format.

juraj

Juraj Trenkler wrote:
I am trying to make a small program for our hospital. It should be a part
of a project which works with dbf files in DOS. As relations are (as far
as I know) impossible with dbf files in linux  I have to export once a
month data from base file to six different dbf files for further
processing. I can do it "manually" but it is intended as a work for
people who are able only put down data in form and push the buttons. Can
anybody help me how to do it as macro? I have no idea.

juraj

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--
Ocke Janssen                      Tel: +49 40 23646 661, x66661
Dipl. Inf(FH)                     Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55                     mailto:[EMAIL PROTECTED]
D-20097 Hamburg                   http://www.sun.com/staroffice

Example isn't another way to teach, it is the only way to teach. Albert Einstein

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to