Importing data?? [modified]

Muammar

Hi, I have a problem and I'm not even sure what question to ask.. I suspect my problem lays in the design, I have these three identical sets of table that are filled independently and when combined at some time to have them in one table we will have the primary key (ID is a primary key in all the table copies) violated (where set to bold) Please, how would you do it D'Oh!

ID IDD Name

1 1 A
2 1 B
3 1 C
1 2 A
2 2 B
3 2 C

ID IDD Name

1 1 A
2 1 B
3 1 C

ID IDD Name

1 2 A
2 2 B
3 2 C

We will either find a way, or make one! (\ /) (- .-) C(''')(''')

modified on Friday, October 23, 2009 4:53 PM

Not Active · modified on Friday, October 23, 2009 4:53 PM

Perhaps it's just my monitor but the bold you mention is difficult to see. If I understand your problem however; First, you could ignore the primary keys and insert the other columns into you new table. Provided there is no associations to them that must be maintained Second, create the combined table as such NewId(PK), ID, IDD, Name

only two letters away from being an asset

Muammar

Thank you Mark, I had the very same thought, but then I'll have to make the NewID primary key column autonumbered "I've done this before".. please notice that these tables are not no the same platform and cant be related as I would export the lower copy and combine it with the upper one "the one you suggested to have a new ID primary column".. Anyhow, thanks mate and I'll just wait for other replays today and if no better solution was suggested, I'll go for this one.

We will either find a way, or make one! (\ /) (- .-) C(''')(''')

Muammar

Hey Mark, just to let you know, I found the answer and it was to simply create a composite key!

We will either find a way, or make one! (\ /) (- .-) C(''')(''')