[alexbrown61]

I get a daily email message that looks like this?? (abbreiviated):

(MESSAGE 1)
AOCDX/PP/TS/312 1756Z//
OPSID/DTR//12345/NOTHING HERE/
ACTI/12/ROUND ABOUT INFORMATION/
COMTECT/123.987MHZ/W9ASG3546/KJDFKAJSDFKD/
RMKS/ THIS IS JUST A REMARK/
LOC/11232E 112344S/
DATETIME/ 1234Z MAR 03//

(MESSAGE 2)
AOCDX/PP/TS/312 1758Z//
OPSID/AFR/56789/SOMETHING HERE/
COMTECT/1234HZ/WRWE987R87W/SDFKJHSADJHSA/
RMKS/THIS IS JUST A REMARK/
CMNT/THIS IS JUST A COMMENT/
LOC/11232E 112344N/
TRK/11232E 112344N/11232E 11245N/11232E 11246N/
DATETIME/1234Z APR 03//

How can I use automation and VB to get this into a useable Access table?

I can get it imported into a blank table but the table is so scranbled that it is not useful. Thanks for any help you can provide.

Alexus

[tadds]

OK I would suggest you define a series of tables. One for each record type that you receive in a single message. This seems the be the first token of each line in the message. Define columns for these tables to hold the various values you receive on each line. This way each row of information will have a unique column in its matching table. Have the datetime be a common column in each table and filled with the DATETIME value from each message. This way you can join all related message information on datetime. As for reading and parsing the message, check out the SPLIT() function in VB. Your tablename will be at index 0.

Enjoy!