Printable View
Hello,
I am not sure of the best way to do this, but I am looking for a way to update a field that is empty with a value from a text file. For example I am importing 5 of 6 fields of data into a table. The 6th field will be left blank. I would like to update that 6th field from data from another file. Can anyone give me a hand with this?
edit: the data for the 6th field will be a single value that will be applied to all the data imported to the first 5 fields.
To be a bit more clear... I am importing a file with 5 fields and on the sixth field of the table I would like to enter the filename of the file I imported. Thanks for any ideas.
How are you importing it at the moment?
If you are using Insert/Insert-From statements it will be easy enough - just a matter of adding an extra field (with the fixed value) to the list.
Right now I am importing with a import specification and a macro made in the access database. I am open to any new ideas tho.