song book help

[no vocals]

Robster,

I usually select the entire songbook, copy and paste into an excel spreadsheet. from there i manually move each section (artist, song, manu) into the appropriate cell next to it. from that point on all you need to do is enter the information each time you purchase new songs. In my case, i get an email conformation of the songs and i can copy/paste from that email directly to the spreadsheet i created in excel. there are about a milllion ways to do it, but this works nicely for me.

[ddouglass]

Instead of copying the information into Excel you can import the data and set it to drop into the cells automatically.

[no vocals]

Originally Posted by ddouglass

Instead of copying the information into Excel you can import the data and set it to drop into the cells automatically.

DD, not to hi-jack the thread, but how does one do that? can it be done with office 2003 or does only 2007 do that?

[ddouglass]

Any Excel version can get external data and since it is all semi-colon separated, then that would be the delimiter.
Look in Excel for Get External Data. It differs from version to version as to where this is located. If you can't find it check in the Help Files for it and that should tell you where to find it and how to use it.

[Roy Dennis]

With Excel 2007 you can open the mdb data base file file directly. But this wont get a page printed like Robster was aking for.

In Excel 2007 click the data tab then from a panel on the left select "From Acces" then just navigate to your songs .mbd file and open it. In the small window that opens select the" Table" radio button and presto.
This isn't so easy in earlier versions to the best of my knowledge.


Roy.

[no vocals]

Cool, DD and Roy, thanks!

[Robster]

ok i will give that a go next week ..

i am seriously tired at the moment Hoster is working 4 gigs a week

Thursday 8 till 11
Friday 7 till 2am
saturday 8 till 2am
and sunday afternoons 4pm to 8pm

need to sleep Monday lol Tuesday i may have a go at this

Thanks for all the help

Rob