Import Help

[John]

I need help with my import. I have a file with 80 fields
in it and I import it into a table. Some of the records
within the import are duplicates with the exception of one
field.
Each person has an account number and each person can have
multiple different account numbers.
Should I create a table to import the data and then create
and append query to move the data to other tables so I
don't have redundent data?
Any advice would be greatly appreciated.

Thanks in advance!

John

 

[Jeff Boyce]

John

Given your situation, in which you have data you want to "massage" to get
into a final form, I would use the approach you described:

Import (or link to) the 'raw' data source;
Create your 'final' table structure;
Append/update from 'raw' to 'final'.

Good luck

Jeff Boyce
<Access MVP>