Best Way to Update Raw Data From Another System

[ttuguy]

Hey all,

I am fairly new to access and still feeling my way around. I am currently working on a project and teaching myself access again after 10+ years of not working with it

I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.

The only have I have found to do this is by running non-matching queries and update queries. Am I missing an easier way??

 

[plog]

Are you changing the data when it gets into Access? Why not just delete all the existing data in the Access data and import and use the new data?

The best way however would be to connect to the Inventory system via a linked table.

 

[ttuguy]

Thanks Plog, that is what I wound up doing. I created a linked table and each time I download the inventory information I save it over the old inventory sheet