Import file with duplicates

[Jaren Meier]

Can anyone tell me how to do the following: I have an .csv file that I would like to import into an existing table. The problem I have is each of the records from the .csv file contains a and a field. If there is more than 1 in the .csv file I only want to enter the one and take the duplicate records and add into a repeating field. What is the best way? How can i merge some records into 1 with repeating fields?

[mr_vodka]

First, I think we have to ask why you are doing this. Repeating fields are not recommended for this sort of thing.

The more proper way of setting this up would be to have two tables. One for dealers and the other for clubs. You could have a table of dealers be a one to many relationship to your table of clubs matching on the dealerID.