Jump to content

Import file with duplicates


Jaren Meier
 Share

This topic is 5775 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5775 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.