I'm just starting to try and teach myself about database programming. I am fluent with setting up a new database in access but have come to understand that ms is doing away with access so I am now trying to learn sql.
My question is, is there a way to populate a database once it is designed, with data automatically? More specifically. I want to create a database of all the karaoke files I have on my system. I know there must be a way, because a couple of karaoke host softwares I have used in the past automatically created a database of an entire directory that you designate. AS it is I already have an existing database created by one of those programs but it is on my old system and is not compatible with windows 8.
I also don't like how the files were entered and would like to edit them to clean them up. In some cases it seems, the files were not tagged correctly and the artist is listed under title and the genre under artist and stuff like that. So when the software accesses the database using a query, sometimes the results are not what they should be.
Will I have to manually populate my database in order to have it all entered correctly since many of the files (i have over 150k song files) were not tagged right?