Creating a query to append new data as well as deleting old data

[Guest]

Hello everyone...I'm new to this discussion group, so please be gentle.

I have a huge Access database that will likely have more than a million
records. This data is actually an extract from another database that I pull
from using Brio. This is transaction data (so lots of records) that I need to
do analysis on. Because of the sheer volume of sales, I've decided to run the
data in Brio in chunks (meaning 3 months at a time) and then import the data
into Access so that I can clean the data and add other things to it.

Since these are transactions, the newer records get updated as things
gradually invoice and get shipped out. I am wanting to delete the last 60
days of data in the database and then re-import the last 60 days once a week
to bring in all of the new transactions as well as update the status of the
transactions that shipped since the last update.

Basically, its having a table of all the transactions (based on several
imported txt files)...then deleting the last 60 days....and then importing
the last 60 days (which comes from another txt file but is linked, not
imported). I am also trying to make this somewhat automated to take myself
out of manually importing the files.

Does anyone have a decent way of doing that or have any experience with
somethign similar? Sorry for my verbose message. and thanks for the help!

 

[[MVP] S.Clark]

You can use macro actions to automate the imports and the delete query.

See in Help:
TransferText
OpenQuery