records

  • Thread starter Thread starter steve
  • Start date Start date
S

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
 
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.
 
Back
Top