by Jonathan Hills » Sun Feb 26, 2006 7:45 pm
I used turbo db 5.0.6
Open the viewer which gives you 2 tabs tables and sql
On the table part where it says <click here to connect to a TurboDB database> browse to the default folder which is c:\program files\zionworx\data. Open any of the tables that appear in the browse box
Go to the sql tab, type either:
select title1, title2, writer, copyright from maintable
or
select title1, title2, writer, lyrics, copyright from maintable
depending on whether you want lyrics or not
Click on the green triangle (or hit F9).
The results are displayed
Click on Data Set at the top
Export records
At the bottom choose a file name (or browse using the ...box)
File type can be text, dbase or xml (any of which can be used in a spreadsheet or database - if using open office, dbase is best if you want the lyrics)
A 10 record preview is shown
Continue
Transfer
"The batch move completed successfully.
214 records have been transfered." You should get this message.