How can I import a single csv file into multiple tables where tables have referential integrity.
For example I need to import a file with name,make,model,waranty,bodystyle into the following tables
model-id,model,makeid (makeid references id from make table) Id is identity
bodystyle-(id,bodystyle) Id is Identity
vehicle(id,makeid,modelid,bodystyleid...) Id is identity here however all these makeid,modelid,bodydtyleid references to Ids from above tables.