Export to CSV from sqlbase 7

Discussion forum about all things SqlBase.
peter47

Export to CSV from sqlbase 7

Post by peter47 » 01 Dec 2015, 07:49

Hi all,

I have to export some tables from an old sqlbase 7 installation. I tried some commands via sqltalk (like set spool and unload ascii).
Unload ascii says that the data is too big. When I export with set spool the data has no consitent length, so it is not really possible to work with the data in excel. Is it possible to set a column delimiter for the sqltalk output?

Best regards

Peter

FRBhote
India
Posts: 2172
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Export to CSV from sqlbase 7

Post by FRBhote » 02 Dec 2015, 06:21

What exactly is the error?

Maybe you can create views of smaller chunks of data and unload them one by one.

gigit
Italy
Posts: 154
Joined: 14 Jun 2017, 15:04
Location: Italy

Re: Export to CSV from sqlbase 7

Post by gigit » 30 Jan 2017, 17:18

select col1,';',col2,';' col3,';',col4

then save sqltalk otuput to a csv file and open it with excel.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests