Morning,
I initially imported a load of pupil records from a csv file into a database table. Now i've been told to include another field for each pupil. I can get this data into csv format, with primary key and the new field data, but how do I "append" this fielddata to the existing table? I think append is only used for new records, and this won't be the case - I'm just updating.
I really just want the new field to be added rather than rebuild the whole table as some data has been changed.
Is there any way of doing this? I've tried looking at help, my manual and these forums, but with no joy. Should I be looking at a 2-step way of importing into a new table and then running an update query?
I'd appreciate any help
jr
I initially imported a load of pupil records from a csv file into a database table. Now i've been told to include another field for each pupil. I can get this data into csv format, with primary key and the new field data, but how do I "append" this fielddata to the existing table? I think append is only used for new records, and this won't be the case - I'm just updating.
I really just want the new field to be added rather than rebuild the whole table as some data has been changed.
Is there any way of doing this? I've tried looking at help, my manual and these forums, but with no joy. Should I be looking at a 2-step way of importing into a new table and then running an update query?
I'd appreciate any help
jr