Hello,
I am very new to Access (and databases in general) and would appreciate any advice anyone has! I have created an Access database to store information from the Learning Management System (LMS) that my company uses. The LMS creates data sets that I download as CSV files and save as Excel Workbook files.
The LMS creates two different types of data sets. There is a full data set created every week, and then differential data sets created every day to capture the differences between the full data sets.
I used a full data set to create a table in Access. Now I am trying to use a differential data set to update the table. So far, the only thing I can figure how to do is to append the differential file to the table. All this does is add in the data from the file. It does not use the data in the file to UPDATE the existing data in the table.
For example: the table I'm currently working with stores data about course offerings. One of the fields is Recycle Date, which stores the date that a course was recycled. For one of the courses I am working with, when I used the full data set to create the table, there was no Recycle Date. In the differential file, there IS a Recycle Data for this course. I want to use the differential file to update the course offering record to add in the recycle date. Is this possible? When I use the append option, the data is just added to the table. I assume I need to identify a common field (key) for Access to use to know when a row in the Excel file matches a row in the Access table and thus needs to be updated, but I am not sure how to do that either.
Any advice/help would be greatly appreciated!