DB exporting song list

[Al]

Hi All, I like to discover a way to export the DB into a song list. With something like using Main Title, Alt title, written by and copyright fields. If the Lyrics field could be experted also that would be great but not essential for my needs.

I've looked at the TurboDB apps mentioned in this forum but find them difficult to use.

Any ideas?

Thanks
Al

[Jonathan Hills]

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.

[Al]

Thanks Jonathan, that's great