Hi All, These days we are working on a lyrics site. I bought some databases from this forum. We decided to use on of them which has about 700k lyrics in it. It was sql so we converted it to access format. But now we have a problem. We wish to share the song's video links at Youtube. But it is nearly impossible to manuelly find the youtube link and write it to our database. I am curious that is there an automatic way to do that? Thanks
First of all, go back to using SQL; Access is rarely ever a suitable RDMS for anything other than a couple of users on a local network. You could write a small application that uses the YouTube Data API (http://code.google.com/apis/youtube/getting_started.html) to search for videos but you would need to read the T&Cs as free services like this normally have a cap on the number of requests you can make and 700,000 may well exceed that.