records

[steve]

does any one know a good way programatically in Access to
convert a text file like the one below into a table
format??
Thanks!!!

AST NAME: CONCANNON
FIRST NAME: PAUL
MIDDLE NAME: Hamilton
ADDRESS 1: 425 Maine Avenue
ADDRESS 2:
CITY: Fairbanks
STATE: NJ
ZIP CODE: 07502
ADMISSION DATE: 8/1/2003

LAST NAME: GREEN
FIRST NAME: Steve
MIDDLE NAME:
ADDRESS 1: 1200 Asbury Ave.
ADDRESS 2:
CITY: Pittsburgh
STATE: PA
ZIP CODE: 15222
ADMISSION DATE: 8/1/2003

LAST NAME: ROBinson
FIRST NAME: Michael
MIDDLE NAME: M
ADDRESS 1: 641 Newark Pompton Turnpike, Apt 25
ADDRESS 2:
CITY: Newark
STATE: NJ
ZIP CODE: 07248
ADMISSION DATE: 8/1/2003

 

[Allen Browne]

Couple of alternatives:

1. Use Word to do some heavy massaging of the file so it ends up in a
delimited format.

2. Use the Open command to open the text file, and parse it in VBA.

 

[TC]

Er, those would be >>fake<< personal details, yes?

TC