B
Bill
I have an Access DB that imports csv files that the user
selects from a table. It works great, thanks to you folks
in here. I'm using the Docmd/transfertext scenario & a
pre-defined table that I've emptied out. The Import spec
is set via a user selection. All works great, but now I
need to import the filename into the table. I'd like it
appended to the beg/end of each row so that when I import
more than 1 file, I can group/sum on my report BY the
originating FileName. My first thought was to add a col
to the table & then after the inport, set any filename
cell that is null, to the file name. Would this work? Is
null the correct thing to test for? Is there an easier
way? Thanks -Bill.
selects from a table. It works great, thanks to you folks
in here. I'm using the Docmd/transfertext scenario & a
pre-defined table that I've emptied out. The Import spec
is set via a user selection. All works great, but now I
need to import the filename into the table. I'd like it
appended to the beg/end of each row so that when I import
more than 1 file, I can group/sum on my report BY the
originating FileName. My first thought was to add a col
to the table & then after the inport, set any filename
cell that is null, to the file name. Would this work? Is
null the correct thing to test for? Is there an easier
way? Thanks -Bill.