I take you are using HSQL and you know about the select into a text
table, just in case.
I have a test datbase with a table named Table1
The table has three columns, one is an integer and the others are varchar
If I execute the following statement
select * into TEXT "tmp3" from "Table1"
I end up with the file tmp3.csv in the same directoryt as my ODB file.
This is the contents
0,9999,New Value
1,1002,cat
2,2001,pigeon
3,2002,hawk
4,3310,turtle
5,3318,snail
So, now we just have to figure out how to make the ',' turn into a '/t'.
I will see what I can do.
Andrew
Kae Verens wrote:
hi,
I have a database table that I'd like to export as a tab-delimited
file.
There does not appear to be a function for doing this in the Base
module. Am I missing something, or is this just not possible?
Kae
---------------------------------------------------------------------
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]