Re: exporting a table

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]
>
>
>
>