need to import data from one access table to another.

[Guest]

I have a table (tbl1)with a unique identifier to the data. Another
table(tbl2) with the same unique identifier. In tbl1, there are multiple
fields all containing the same data(calling them df01 - df10), a 7 digit text
field. In the field before each df field I have an identfier which can be
three different types (DF,DA or a PC). They also have a number after them,
ie (DF 01 or DF 02 or PC 01 or DA 01). They can be in any order. Right now
in tlb1 I have field df01 with mostly DF 01 data in them. However there are
DA 01 and PC 01 data in the same column. I would like to move the data into
tbl2 into fields called df01 - df10, DA 01 ( there is only one DA), and PC 01
- 10, based on the prior field value. Also in tbl1, there can be multiple
instances of the unique identifier. This is because of the way we get the
data over time. there can be an update several monthly after the Visit date.
It does matter that the value with df 01 goes into df01 and df 02 goes into
df02, etc. Some rows have two or three values, some have up to 45. How do
I import them into tbl2?

 

[John Nurick]

Hi Sergio,

Use an append query, with whatever criteria you need.