Unanswered: Importing from an old DB into a new DB
I have an old database which contains two field that I would like to combine into one field in the new database. Can I do this in one import? If so, how? If not, can I do this with two separate imports? I have tried to do two separate imports but when I do the second, the information form the first is lost.
To import data for once from two fields at once, it is possible to create a calculated field in which to collect data from two fields in old base. And to import to new base data from this calculated field.
Or create an update query with the recordsource as the otld table, the destination table the new table. To make life easier you could even create the new column in the existing table, then create the update query to update that column with the desired values
create a new query
in the query types / options specify an aupdate query