Assuming your database is from HSQL, the 'embedded' database, another option is a macro.
The link below, please see the LAST post by Sliderule ( yours truly ) includes a macro where you can include via passed parameters, OR, prompts:
- Table name, View name, OR Query name ( including queries with prompts )
- Output file name
- Header-Yes OR Header-No ( column names to be included in output file )
- Registered file name
If you use the macro, please be sure to change, at the beginning, YOUR DEFAULTS.
This macro can be run:
- From Calc ( with output to a file )
- From another macro
- From a form
- From the toolbar - Macro -> Run
I hope this helps, please be sure to let me / us know.
Thanks to add [Solved]
in your first post Subject ( edit button top right ) if your issue has been fixed / resolved.