Will table overwrite table?

[uglydork]

If I pull in a table from another database that is the same as the table I use in my database ,only newer information, will the new table overwirte information or only add information such as updated numbers?

 

[HiTechCoach]

It will depend on how you "pull" in the table.

Will you explain in more detail exactly what you are doing?

 

[uglydork]

The table names are both table 27.
I have one in my database that reps use to input phone numbers that I use for an outbound calling campaign before we turn off electricity.
The second table 27 is updated daily from the main system. I pull it once a week so I have proper KHW usage and I know who isnt paying their bill.
I need to pull the second table 27 with the updated information from the main system and import it into my database. If the phone number field is filled in, I want that row to skip and not update in my database. I have the number, I dont ned the new updated information so it can be skipped.

Wht I dont want is my table 27 to have multiple same records. If my reps capture the phone number at an address, it can be skipped when updating my table.

I usually export the table 27 and rename it in my database. I them copy it to my table 27.

Confusing?

 

[Rich]

You could use a FindDuplicates query, filter out the unwanted records and then change that query to an AppendQuery

 

[uglydork]

You could use a FindDuplicates query, filter out the unwanted records and then change that query to an AppendQuery

Thank you Rich. That brings me back to my original question. When I import table 27 into my table 27 will it add all the records even though they are duplicates or will it overwite the records?
The only thing that will have changed is KHW usage, all other fields will be the same.

 

[Rich]

Import the table with a new name then compare the two