Append data during import?

[poz]

Is it possible to append data during the import process. I have added a new field to my table and would like to append data to that field during the import process from an external data file. I import approx 10 files to a single table, but I need the appended data to be different for each file imported and not overwritten. Can this be done?

[CyborgSam]

Welcome to the Forums!

Yes. In a simple scenario, when importing change the Import Option from Add new records to Update existing records in found set. Then select the new field as the recipient of the imported data.

If you different records for each of the 10 files, do a search and a sort before each file's import so the found set matches the file's records and order.

[Vaughan]

There is a better method: create a relationship between the two tables/files. Use the Replace command and specify a calculation that appeands the data into the field via the relationahip.

Lastly, import any records from the new file that don't exist in the old table.