DTS and excel when there are FK constraints

[ciproectadina]

Hi all, I need to populate several base tables inside a database, but they alsmot every table has FKs and relates to other tables, I have some values in excel files but I cannot seem to turn off the FK checks while importing data or how to make sure the FKs values are there?
Any ideas? Wouldn't it be better with a complex database design (with many relationships) to create an access project with SQL server in the backend to enter the data? I running out of ideas to make this work...
L.

 

[Idokyoku2]

Have you tried importing to a table with the Primary Key first?

David

 

[Idokyoku2]

ciproectadina,
I just searched on 'Disable Foreign Key Constraint' and came up with this thread, it may solve your problem: thread183-129511. I've not seen this person post before, but seems fairly knowledgeable.

David