I have a local access db that I use for exporting/importing and updating to a online sql server db.
I have used INSERT INTO and UPDATE to accomplish this in a single table. But what if I have two tables with a FK in the second table, is there any way of exporting/importing and doing update to several tables in one singel query? Or do I need several quries, one for each table.
thanks
Sohail