XP & Access 2003
I'm debugging someone elses code that imports a CSV email attachment
and appends each record of the file to a table in the database.
Everything works great except one entry of the CSV file is being
appended to the wrong column in the Table. E.g., the table entry
"Product" is accidentally being inserted into "Title." It seems
simple enough to debug and fix, but I can't for the life of me figure
out where the entry assignments are located.
I think I narrowed it down to the line:
DoCmd.TransferText acImportDelim, "PGHQ", "DataT", fn, colhdr
Where "DataT" is the table being appended to, 'fn' is the path to the
email attachment file being read and appended. I suspect that "PGHQ"
is where the columns/entries are assigned, but I don't know where
"PGHQ" is specified. I don't see any tables by this name in the
database, nor do I see any text files outside. I've been pulling my
hair out for a while on this. If someone could clue me in, it would
be much appreciated.
Thanks,
Rich