Jaren Meier Posted December 5, 2006 Share Posted December 5, 2006 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 More sharing options...
mr_vodka Posted December 6, 2006 Share Posted December 6, 2006 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 More sharing options...
Recommended Posts
This topic is 6351 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 accountSign in
Already have an account? Sign in here.
Sign In Now