A
AccessNewbie
I just thought of a possible solution, but I would need to know if it seems
viable from someone....
How about in my case, I just create an empty (Null) field in my data table
(the one that came from Excel), and I create a field of the same type (text)
in the template table. I then run an update query and creat a join between
the two tables with the blank fields....and choose the option to include ALL
records from the data table and only those where the template table are
equal.
Would that trick access into running my append the way I want?
Thanks again for a response, I am needing to complete this portion of the
project ASAP!
viable from someone....
How about in my case, I just create an empty (Null) field in my data table
(the one that came from Excel), and I create a field of the same type (text)
in the template table. I then run an update query and creat a join between
the two tables with the blank fields....and choose the option to include ALL
records from the data table and only those where the template table are
equal.
Would that trick access into running my append the way I want?
Thanks again for a response, I am needing to complete this portion of the
project ASAP!