D
dman
Hi.
I had a macro setup to import a text file into a table, however, I found out
one the fields in the table will not be available in the text file. Instead
of providing
SSN# in the text file, I will have Employee ID.
There is an Employee table that I can 'lookup' the SSN# from the Emp ID. Can
this
be done in a macro during the import, or do I have to write some VBA code to
accomplish this?
Thanks.
D
I had a macro setup to import a text file into a table, however, I found out
one the fields in the table will not be available in the text file. Instead
of providing
SSN# in the text file, I will have Employee ID.
There is an Employee table that I can 'lookup' the SSN# from the Emp ID. Can
this
be done in a macro during the import, or do I have to write some VBA code to
accomplish this?
Thanks.
D