Duplicate Lines in Excel Import Mess up Primary Key

[accessdave84]

Hello All,

Thank you in advance for helping with this!

I'm brand new this forum and an Access noobie but I have a good amount of experience with Excel. I've got a CSV table of UPS shipping data which has multiple lines for each entry. Meaning that what I thought would be the primary key (the unique tracking #) is repeated 2 or 3 times with each record. There is additional information that is provided on the duplicate rows; a handful of fields with Fuel Surcharge costs. So I can't remove these rows without adding that data back in somehow.

Any thoughts would be much appreciated.

Thanks,

Accessdave84

[ranman256]

You could do a 2 pass import:
Query 1, a UNIQUE query to import the keys.
query. 2, a query to import the data

[accessdave84]

Thanks for the help. That makes a lot of sense!