Not sure I understand you 100%, but you could try the following
select *
into your_new_table
from your_old_table
both tables will need to be in the same database. If having the tables in
one db ios not an option, you could alternativly select all records from
one db, then loop over the output inserting one record at a time into the
new db and datasource.
At 12:50 AM 26/03/00 +0100, you wrote:
>I have two different DBs and two different independent tables in those DBs.
>Both tables do not have the same number of records.
>The records of one table can be erased first.
>
>How can I overwrite/transfer the records of one table with the records of
>the other table ?
>Delete all records of the first table in the beginning and then do a
>cfquery/insert into from one table to the other ?
>
>Is there the idea of a CF-Transfer-Function similar like in a SQL-Server ?
>
>Ideas ?
>
>Uwe
>
>
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
