Hello. I'm attempting to combine two databases and I'm not certain if I can use SQL or if I need VBA. I'm new to both. The two databases contain retail product information such as UPC code, prices, etc. I often need to campare a new database against an old database and I would like to simplify life by achieving the following:
-Any new product not in the old database needs to be added to the old database (The UPC, item number, description and price just needs to be added to the end of the old database).
-Any price changes in the new database need to be updated in the old database.
-I need to print a list of only products which have had a price change.
-Any product in the old database which is not the new database has been discontinued and I need to flag it as discontinued. Perhaps by adding a "*" in the description.
Possible with SQL? Any help appreciated.
Thanks.
-Any new product not in the old database needs to be added to the old database (The UPC, item number, description and price just needs to be added to the end of the old database).
-Any price changes in the new database need to be updated in the old database.
-I need to print a list of only products which have had a price change.
-Any product in the old database which is not the new database has been discontinued and I need to flag it as discontinued. Perhaps by adding a "*" in the description.
Possible with SQL? Any help appreciated.
Thanks.
