adding new records from one table to an existing table

[Josh Wexler]

I'm pretty new to access so please bear with me. This may be really
simple. I have a table listing thousands of existing stores. In the
existing table i have a lot of geographic information including lat/
long, address, etc. Periodically I will need to add new records from
another table. However, in the new table the field names aren't
identical. ie....in the original table i have Original Address 1 and
in the new table it says Address 1. I also don't have all the fields
in the new table. So i need to add in the new records with their
corresponding fields(i will fill in the missing fields later). i
can't seem to do this. I have been trying to do an append query, but
it's failing, i believe due to having different named fields.

Thanks for any help.

 

[Jerry Whittle]

If you are doing the append query from the QBE grid, you should be able to
select the fields from the table. If the field names were the same, Access
would assume that's what you want. As your names are different, you'll need
to select the field names.

 

[kingston via AccessMonster.com]

You're on the right track by using an append query. What happens when you
try to run the query? Is there an error message? Make sure you set the
Append To: line correctly since the field names are not the same (e.g. Field:
Original Address 1 and Append To: Address 1). Also, if there is a required
field in the target table that doesn't exist in the source table, you may
need to enter default data in the Field: line.

 

[Josh Wexler]

Thanks for the help. I'm an idiot. That was so ridiculously easy.