Quote Originally Posted by WoF View Post
That sounds as if you would like to make lists of all the fine and completely copyright-free tracks of music you own and send this list out to your thousands of friends, who will select any number of tracks they'd like you to put on a CD for them, so as you can gladly and without any commercial interest or even friendly reward burn CDs for them.

That's very generous and big-hearted, and if I was so magnanimous, I'd start over with an Access database and when I have some data entered, I'd use VB6 and ADO data access elements to do the program.
I started a music company supplying music from musicians and composers that have signed contracts with me, to companies that use music as part of their work - tv programme producers, ad agencies etc.

The number of tracks that have come in has increased and each one has multiple columns of data in Excel. I've read on other forums that Excel (and Access?) can have trouble filtering more than 1000 records (not sure how true this is but I don't want to find out after spending time coding) hence the need for a standalone programme that I can re-compile when the need arises, and that can handle thousands of records.

So... if I have this right, I export the Excel sheet for use by Access, if Access doesn't have the Issues I read about.
I then find some routines (is that the right word?) that I can adapt to suit my own needs.

Is there a library of routines that are downloadable anywhere, or do I have to start from scratch?
I only chose VB as it sounded like it may be kind of familiar to me, being an old BASIC programmer.

Thanks