Append query with different field names

  • Thread starter Thread starter FJB
  • Start date Start date
F

FJB

I will soon have access to an Access database from which I will obtain
data using a query. I need to append a table in another Access database
with the information from the first table. The field names in each
table are different from the other table. For example, "Case
Number" needs to be appended as "ICMS case number". What is the
best, and easiest, way to make this happen?

Thanks
 
I will soon have access to an Access database from which I will obtain
data using a query. I need to append a table in another Access database
with the information from the first table. The field names in each
table are different from the other table. For example, "Case
Number" needs to be appended as "ICMS case number". What is the
best, and easiest, way to make this happen?

Thanks
Click to expand...

Create an Append query based on the source table, and use the desired
new names as the fields to be appended to. There is no necessity or
expectation that these be the same! E.g.

INSERT INTO targettable
([ICMS Case Number], [Surname], [Forename], [DateOfBirth])
SELECT [Case Number], [Last Name], [First Name], [DOB]
FROM sourcetable;

John W. Vinson[MVP]
 
If the tables are in 2 different databases, won't he have to link the
destination table to the source database?

Randall Arnold

John Vinson said:
I will soon have access to an Access database from which I will obtain
data using a query. I need to append a table in another Access database
with the information from the first table. The field names in each
table are different from the other table. For example, "Case
Number" needs to be appended as "ICMS case number". What is the
best, and easiest, way to make this happen?

Thanks
Click to expand...

Create an Append query based on the source table, and use the desired
new names as the fields to be appended to. There is no necessity or
expectation that these be the same! E.g.

INSERT INTO targettable
([ICMS Case Number], [Surname], [Forename], [DateOfBirth])
SELECT [Case Number], [Last Name], [First Name], [DOB]
FROM sourcetable;

John W. Vinson[MVP]
Click to expand...
 
Back
Top