Ok I might have done something wrong.
This what I have:
I have a button macro which when pressed prompts me for the file I want to upload. The data is uploaded to Daily_cumulative.
tbl_Import should display for me the name (or path) of the file I just uploaded as well as date/time.
If I understand you correctly. I need to add the fields "FileSource" and "ImportDate" to the Daily_cumulative table, correct?
I tried this and still I get nothing...
I'm so sorry about this, but I am really an amateur at all this
Originally Posted by pbaldy
The method is intended to be used where the import will populate most of the fields, leaving this one Null. This query will populate that last field. For example, the second time you run the process, the previously imported records will have this field populated but the new records will not. The query given will thus populate the newly imported records leaving the older ones alone.