Hi Al,
Yes, this is possible using VBA code. It is not uncommon to have to take data that has been
stored in multiple columns in Excel (example: January Sales, February Sales, March Sales, etc.)
and re-write it into as individual records in an Access table, in order to achieve a normalized
data structure. The general idea is to open two recordsets; one to read each record from the
un-normalized source table and the other to write the result to a new normalized target table.
You read each column in each record from the source table and write the result to the target
table. You continue in a loop until all values have been transferred.
I have some examples that I can send to you, if you'd like. Are you comfortable using VBA code?
Tom
______________________________________
Hello-
I want the records in one column of a table to be the fields of another
table?
Is this possible?
Thank you
Al
Access 2000
