Songbook

[RWGRAH]

I have just purchased a case to store my CDG's in that pops them up by disk number.

Is there a way to create a songbook by book ID number and not artist or title?

[admin]

Yep!

Read the Hoster manual SongBook section, and pay attention to BookID.

[admin]

I moved this to Hoster Help where it belongs so others will see it and help you also.

[kilith]

Ok I have been trying to read about this in the manual and almost anywhere else. How in the world do you make the book open up in Excel and actually use the fields the right way?

I just get a jumble of everything in A1 and does not format to look like a book. Thing is I love the format of listing by artist in Word format. I think listing by song is messy and unreadable in word and having by song title in excel would be more easy to read.

Any help would be nice if anyone has figured this out.

[Jacqui]

In Hoster Build song database, when complete goto the folder where your
database is stored.
"C:\Program Files\Micro Technology Unlimited\Hoster\Databases"
double click on your database file "SONGS.MDB and the file should open
in Microsoft Access click on OPEN and you should be able to see your file.

Do not edit the file at this time
Click on File and then click on save As/Export and the click "OK"
Click the down arrow "Save As Type" I use "Microsoft Excel 97 (*.xls)
Or whatevev Excel you use.
On the right side of the window check "Save Formatted"
then click "Export"

Now load your SONGS.xls with Excel and setup your songbook whetever
way you want.

Pres

[kilith]

Thank you. Saves a TON of work! Only thing I do not understand is then why do they offer under create book to use Excel if the program will not create an Excel spread sheet?

[Beavis]

Originally Posted by kilith

Thank you. Saves a TON of work! Only thing I do not understand is then why do they offer under create book to use Excel if the program will not create an Excel spread sheet?

trust me when you convert to there format of using the book id you will never look back.

i use to use excell and when i made the switch, i said to myself, "SELF" what were you thinking