A
Alexes
I am trying to import a coded message into a table that I can
manipulate in Access 2002. The message comes in the body of an email
and looks like this:
ACTIVITY LOG
AOCDX/PP/R2/D2//
RMKS/THIS IS A REMARK//
COMTECH/CASE/123.567MHZ//
AOCDX/OO/R1/D1//
OPSUM/CODE/CODE/AIR ACTIVITY//
COMMENT/THIS IS JUST A COMMENT//
RMKS/THIS IS A REMARK//
AOCDX/OO/R6/D6//
OPSUM/CODE/CODE/AIR ACTIVITY//
COMMENT/THIS IS JUST A COMMENT//
RMKS/THIS IS A REMARK//
LOC/112233N 224455E/223344S 445566W//
I have tried for the last two weeks to find a way to get this into an
access table that uses each UNIQUE coded field (data between the
slashes (/) as a column. The example above would need 18 different
columns. I am able to import using TransferText with an import spec by
replacing the double slashes at the end of each line prior to import
but the table looks exactly like the message without the slashes. Is
there a way to parse field-to-field automatically using queries,
recodsets, macros or am I stuck? There is no way to have the message
sent in a simpler format. Any references or examples (I'm a newbie)
greatly appreciated. Thanks.
Alexes
manipulate in Access 2002. The message comes in the body of an email
and looks like this:
ACTIVITY LOG
AOCDX/PP/R2/D2//
RMKS/THIS IS A REMARK//
COMTECH/CASE/123.567MHZ//
AOCDX/OO/R1/D1//
OPSUM/CODE/CODE/AIR ACTIVITY//
COMMENT/THIS IS JUST A COMMENT//
RMKS/THIS IS A REMARK//
AOCDX/OO/R6/D6//
OPSUM/CODE/CODE/AIR ACTIVITY//
COMMENT/THIS IS JUST A COMMENT//
RMKS/THIS IS A REMARK//
LOC/112233N 224455E/223344S 445566W//
I have tried for the last two weeks to find a way to get this into an
access table that uses each UNIQUE coded field (data between the
slashes (/) as a column. The example above would need 18 different
columns. I am able to import using TransferText with an import spec by
replacing the double slashes at the end of each line prior to import
but the table looks exactly like the message without the slashes. Is
there a way to parse field-to-field automatically using queries,
recodsets, macros or am I stuck? There is no way to have the message
sent in a simpler format. Any references or examples (I'm a newbie)
greatly appreciated. Thanks.
Alexes