Hi,
I’m a novice with Access (2003), and right now I need some help.
I receive a fixed-length text file from the state on a daily basis that
needs to be im****ted into an access table. This table needs to have the
date
it was received from the state as the primary key. However, the state,
being
the state (Alabama), does not include this as part of the record of the
file.
However, the needed date is part of the file name, as follows:
4194400808040300.txt
Or
NSA8227051080804.txt
The 080804 being YYMMDD format.
I have created a crude macro that will im****t what I need to build my
table,
with the exception being that primary key, whether it is the entire
filename
or just the YYMMDD ****tion of the file name.
Is there a way I populate the primary key with as user prompt incor****ated
in my macro?
At this point, any help would be appreciated.
Thanks!
--
LH
|
