Moving data from temp table to other tables (procedure?)

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

Guest

Hello,

I have seen the questions about moving data from one table to another and
realize it may not be the best way to go, so please advise if another way is
better for this situation.
I have created a temporary table(temptable) to import data from a Word Form.
The temptable has information that needs to be transferred to about 3 other
tables all based on a four-digit employee number as well as based on if the
employee number Exists in the other three tables. My thought was to write a
procedure to do so. My problem is I have never done this in Access (using
version 2003) and it has been quite a few years since doing something like
this at all. So I am not sure now to get this started. I have thought about
If statements or a For...Next, but am unclear which would be best.

Thank you in advance for any help.
 
THe best way to move data from table to table is usually with an append
query or update query. These can be called from VBA procedures
(CurrentDB.Execute...). Sometimes one needs to write VBA code to create
the SQL statement for the desired query, but it's seldom necessary to
write code that loops through individual records.
 
Back
Top