G'Day,
If we have the following tables:
TblVenues, Import_tblVenues with the following structure:
VenueCode (PRIMARY KEY)
Description
Location
I have a scenario where data is placed into the Import_tblVenues table and I
then want to transfer that information into a production table called
Donovan
Try this, Assumes you can type the PK (and it is a single field) but with a
little fiddling you could make that dynamic (use syscolums)
you can also get the PK Constrain field out of syscontraints, all depends on
how 'smart' you want to get
For eff reasons i'd submit the synch raw data