Excel Songbook

[rcrosier]

I use Access to print my songbooks. I wrote some custom queries and reports, and used ODBC to connect to the SONGS.MDB file directly (or a copy of it), and I use an HP Photosmart p1100 printer with a duplexing option (prints on both sides of the page).

This works INCREDIBLY well. I print four books every time I have purchased a significant number of new songs, each with a section by ARTIST and SONG TITLE. I also print a section of ONLY vocal assist songs.

I can print 3000 songs in about 30 pages, compared to 81 pages using the built-in book.