If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A fast and Easy way to populate records from Temp Table to Permanent Table?
Hi all,
I am trying to solve a problem for the company which I chosed to use Temp table. In some certain conditions, we need to populates all the records from the temp table to the Permanent table for storage and further process. Is there a way which I could easily populate the records from Temp to Perm? Two tables are basically identical, except both of them has a unique Automatically generated ID field. Thanks. |
#2
|
|||
|
|||
A fast and Easy way to populate records from Temp Table to Permanent Table?
You can execute an Append query to add the new records in the Temp table to
the Permanent table, but there are many factors that are likely to turn the process into anything but "a fast and easy way" to handle your data. Examples: a) Are they all new records? Or might some be edits of existing records? b) Could other users be entering/editing/deleting records in the permanent table (or in your temp table), and if so, how will you handle clashes? c) The automatically generated ID probably won't work. Whatever number is assigned in your temp table could potentially clash with a record in the permanent table. You might consider replication, but be aware that it has been removed from the new format in A2007 so that might be a dead-end street. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Aldred@office" aldred wrote in message ... I am trying to solve a problem for the company which I chosed to use Temp table. In some certain conditions, we need to populates all the records from the temp table to the Permanent table for storage and further process. Is there a way which I could easily populate the records from Temp to Perm? Two tables are basically identical, except both of them has a unique Automatically generated ID field. |
Thread Tools | |
Display Modes | |
|
|