Import data and update changed information

[MMC]

I have a DB2 database that is used to store information. I currently run
queries on the DB2 database using QMF and generate various reports in Excel.
I want to import those reports into an Access DB on a daily basis. Some of
the data will be static and will not change but some of the information could
and does get updated. Can I import the data into Access and have the system
update any changed information for the records? Plus I also want a comments
field in the Access database that would only get updated by a user manually
via a form in Access. Please help. Thanks.

 

[Klatuu]

Why do you need to go through Excel? You could just use an ODBC connection
to link the DB2 tables directly.

If there is a reason to go through Excel, you could like to the Excel sheets
as tables. Then use append and update queries to get the data into Access
as you want it. If you don't include your comments field in the queries, it
will not be affected.

Linking to external data is usually a better plan than importing the raw
data, massaging it, and deleting the imported raw data because in the latter
case, you will get more bloating.