Hi All - I have the pleasure of trying to parse extracted text into a table. I seem to have plateaued with Excel/Access/RegEx/Google and would appreciate a kick-start!

I'm having the hardest time finding snippets to code I understand and will work with my Windows Environment (Windows 10 - Access 1707 Office 365)

The text below is a sample of the thousands of line's I need to process. My current thought is to
open text file
var = readline.text
int misc = 1 /*keep tally of records that fail CASE()
Case Left(text,3) =
"(G-"
misc = 1
new record
FieldA = var
"P." = FieldB = var
"PA"....etc
else
copy var to Field(misc)
misc++
End Case

PS. WOW so many variants of VBA, ADO DAO how do you know what to do?!?!

=======data below=====
(G-1723)Aberdeen - Brown READY BOX CO (HQ) ??
Storage Division
Also Called RBC
704 Lawrence Rd (99999-9999)
P.O. Box 6 (99999-9999)
PHONE......................999 999-9999
TOLL FREE: 800 999-9999
FAX: 999 999-9999
Paul Smith, President
Cliff Smith, VP Marketing
C T House, Plant Manager
EMP: 50 EST: 1992
SQ FT: 11,000
SALES (est): 17.2MM Publicly Held
SALES (corp-wide): 1.2B
WEB: website
SIC: 2657 2675 2679 Folding paperboard boxes;
die cutting
HQ: Intl Box Co
500 5th Ave
New York, NY 10001
212 800-4800
ANYTOWN
Any County
(G-11)Aberdeen - Moore INTERNTNAL TRAY PADS
PACKG INC
3299 Nc Highway 5 (28315-8619)
P.O. Box 307 (28315-0307)
PHONE...................................910 944-1800
Fax: 910 944-7356
XJ Knorr, President
XKirkpatrick, Corp Secy
XHogan, Shareholder
EMP: 35
SQ FT: 100,000
SALES (est): 4.2MM Privately Held
WEB: website
SIC: 2671 5199 Packaging paper & plastics
film, coated & laminated; packaging
materials
HQ: Pactiv Llc
1900 W Field Ct
Lake Forest IL 60045
847 482-2000
(G-12)Aberdeen - Moore JONATHON M FRANCIS
Also Called: Francis Fabricators & Erectors
240 Crestline Ln (28315-7797)
P.O. Box 142 (28315-0142)
PHONE...................................910 585-8112
XFrancis, Owner
XFrancis, Officer
EMP: 7
SALES (est): 280K Privately Held
SIC: 1541 3441 Steel building construction;
building components, structural steel
(G-13)Aberdeen - Moore KOLCRAFT ENTERPRISES INC
10832 Nc Highway 211 E (28315-4722)
PHONE...................................910 944-9345
Fax: 910 944-3490
XCunliffe, General Mgr
XBird, Vice Pres
XDanko, Vice Pres
XCharles, Sales Mgr
XSchuchard, Manager
EMP: 169
SALES (corp-wide): 29.8MM Privately
Held
SIC: 2512 2511 Juvenile furniture: upholstered
on wood frames; wood household
furniture
PA: Kolcraft Enterprises, Inc.
1100 W Monroe St Ste 1
Chicago IL 60607
312 361-6315