I have an ACCESS database that is million+ lines. I import the data from another database (ORACLE) in order that I can manipulate it (add details etc).
Due to the enormity of the database, I create select queries and then take that data to EXCEL in order to add the details.
(To clarify, the data is invoice data and I add classification to the data- such as "TELECOM" or "PRINT")
So, what I need to know is how to upload the data that I changed on to the database. I know how to update for a single value (ie where the vendor is "VENDOR A" update type to "PRINT"", but how do I update multiple rows with multiple values??
There are unique values to link the tables, so I figure I need to import the excel table back into the database, and then create a relationship. But I'm lost as to what's next. So something like where table1:uniqueID = table2:uniqueID update "TYPE" to "TYPE".
I guess I could always just strip out all of the columns that would be repeated in each table, and just have the columns that I update in one table, and the static data in another. But not every record would have one in the second table.
I'm lost
Bookmarks