That really depends on your database. In SQL server you can create a "DTS" package that will do this. You can also schedule it to run automatically as often as you want.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Charles Brown Sent: Wednesday, September 11, 2002 2:01 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Adding Table A Contents to Table B How do I add the contents of one table to another table? I have two "identical" tables, each in a different data base. I need to routinely empty Table B and add the contents of Table A to Table B (actually a subset of the contents of Table A to Tabnle B). I think I can empty Table B by using a selection criteria general enough in the "Delete" action to catch all the indexed records (e.g., >=1 for the auto increment index field should catch all the records in the Table). There is bound to be a simple way to use the "Insert" action to add the contents of Table A to Table B. Or not. Any suggestions will be greatly appreciated. ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
