Thread: Excel Songbook
View Single Post
  #10  
Old January 14th, 2005, 03:17 PM
rcrosier rcrosier is offline
Registered User
 
Join Date: May 2004
Location: Vermont
Posts: 42
Re: Excel Songbook

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.
Reply With Quote