Exporting BASE tables to text?

[horst.graben]

The subject just about says it all!

Can one export tables to text files (without copy and paste) ?

Thank you!

[DrewJensen]

Tools > SQL

In the SQL window enter the following:

SELECT * INTO TEXT "Table1TXT" FROM "Table1";
DROP TABLE "Table1TXT";

Execute the statements.

Assuming you had a table named Table1, you now have a file named Table1TXT.csv in the same directory as the Base file.

The default settings are for commas separating fields, nothing quoted IIRC. For specifics on setting options look at
HSQLdb Users Manual

Drew