Getting data from one table to another
Posted on 2004-10-06
I have a simple, novice like question. Ive got an app, thanks to RobertRFreeman, that imports data from a txt file to a sql table...everything works great and I couldnt be happier about it. But what I need to do now is move this information from the temp table to the production table and in the process have the option via two check boxes to insert over the existing data or to update and add to the existing data. Example...
If chkbox1 is checked then insert into and if chkbox2 is checked then update and add to the existing information.
Thanks alot for all the help this site is absolutely the best.