Access Help!! Table and Data xfer

[AccessHelp1234]

Hello Everyone,
I need help with Access 2007. I have ONE table with 5 fields and I need to append that data in a different table..but I need to post the data in a different field. (basically, take data from one field and put it another table but in a different field name) For example:



Fields from Table 1: to Fields in Table 2:
Name = Customer Name
Address = Customer Address
ZipCode = Customer ZipCode
PhoneNumber = Customer PhoneNumber

P.s. I dont want to just change the names in Table 1. I actually want to xfer into another table with different field names. THANK YOU!

[pbaldy]

You can create an append query, and specify the appropriate destination field for each source field.

[AccessHelp1234]

I tried the append query, but it appears that I can't choose a difference Field Name in a Different Table, that's my main goal. The append query just appends to the same field name. Maybe it needs to be modified. How do I accomplish this? Again, see below for what my goal is. THANKS!!


Table 1 Fields to Table 2 Fields
Name = CustomerName
Address = CustomerAddress
ZipCode = Customer ZipCode
PhNumber = Customer PhNumber

[pbaldy]

In design view, you can choose any field you want from the destination table in the Append To row. In SQL view:

INSERT INTO TargetTable (TargetFieldName1, TargetFieldName2)
SELECT SourceFieldName1, SourceFieldName2
FROM SourceTable