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
|
|||
|
|||
Make Table v. Append to Table: Need Some Expert Design Inputs
I am working on updates to a couple related databases (not linked by any
tables) and have a question about virtues of Make Table vs Append queries. Make Table: I understand that this will create a NEW table where ever it is pointed, so if that table already exists in the destination it will be deleted, and the new table written in its place. Append : In this case I understand that it would require a little more "work" to do same as Make Table, i.e. clearing out table before appending data. The 1st major difference, other than additional steps, I can see is if you have a table structure you wish to retain the Append qry idea might be more favorable over the Make table qry. Okay, now you database gurus... (1) Are there any other advantages/difierences one over the other?; and (2) What about database size impacts. grow/shrink, assuming the amount of data is fairly consistent from time to time of run? -- MJ |
Thread Tools | |
Display Modes | |
|
|