'insert' or 'append' from Approach

[cobweb]

Hi there:

I am looking to select date from an Approach (dbf) database and insert or append the data into another dbf file.
The export routine in Approach simply creates a new table, obliterating all data in there already.
Does anybody out there know how to insert and append data from one table to another?

Importing from the recipient table is an option, I know, but I want to change a field in the exporting table to 'Posted'. If I could do that from the recipient that would help....

THanks in anticipation

Cobweb.
Ps I did post the 'plea for Improv' the other day; can anybody remeber the product?

 

[suesloan]

Just export a variable-type field with the value of the "posted" field, then import the table and it will append the records.

Sue Sloan

 

[cobweb]

Of Course!

Import from both ends!

As Homer would say - Doh!

Thanks, Sue