Hey guys;
I just installed MS Access 2019 (365 sub) and am in the process of creating a new database for my music library.
The old db was created in Access 2010 (accdb), but had become a bit confusing and possibly corrupt, so I created a bran-new one in 2019.
Now, I would like to copy data from the old to the new database.
Currently, I have set up tables in the new db, with relationships as I want them.
I'm thinking there's got to be a method, using VBA (which I am familiar enough with to do some coding) to accomplish what I want.
Basically, I need to query the old db table (songs) and copy the songs into the correct album in the new db.
Perhaps if I copy the table from the old db to the new, and build an update query? But from what I read, an update query cannot add new records; only change existing ones.
Like I said; I'm somewhat familiar with VBA, but don't have enough experience with it to do something like this.
I am uploading both the databases.
If anyone can help, I would greatly appreciate it, but I don't want anyone to do the work for me. I want to learn VBA, and this could be a good opportunity.
Link to .zip file containing both databases. The file has been scanned by ESET Internet Security and is clean.
https://drive.google.com/open?id=1Xj...WW-dgmuAv03dL_
Thanks for your help
FW