Append Query for records restore

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database that for about 15 days, the users were entering wrong data
in the forms.I replaced the tables so the employees could continue to enter
data on a daily basis.I now want to transfer the 15 days of corrected records
back into this database so for example......data is missing from 11/01/04 to
11/15/04 so there exists this gap of missing records, how do i tranfer in
these records?
Thanks for the support
 
One way would be to link to the database that has the corrected records, and
use an append query to copy those data into your permanent tables.
 
Thanks Ken,

I have never used an append query.I do see it in the options within design
of the query.Do i import the tables involved into the design since the data
entry fills in three tables and of course i need the same structure.How do i
go and identify the 15 days since the data entry continued on the 16 so what
i need is to import all records dated 11/01/2004 thru 11/15/2004.Sorry for
all the questions,
 
You do not need to import the data that you will use as the source data. You
can just link to the database that has those data in it; do this by File |
Get External Data \ Link.

Then build your query just as you normally would. You write the query to
select the data that you want to append to your permanent table. To select
just the "missing" data, you can use a "Criteria:" expression similar to
this for the field that contains the date values:
Between #11/1/2004# And #11/15/2004#

Then, you change the query type to an Append query; identify the table that
is to get the data when the window appears that asks for the table name.

After you run the query, you can remove the links to the data tables from
which you got the source data by just highlighting the table name in the
database window and pressing Delete key.
--

Ken Snell
<MS ACCESS MVP>
 
Back
Top