Is it possible to import Excel file to Access table when it is not set as table, but it is more like a document where data is located all over the sheet.
please see below.


SET-UP INFORMATION      
      
PART NO:  JRB7178  MACHINE PROGRAM #:  T06-01-0025
CUSTOMER:  ROLLS ROYCE  REVISION / UPLOAD DATE:  12/7/2015
CYCLE TIME:  ?  OPERATION SEQ. NO.:  164
    PROGRAM ORIGIN:  "z" zero is front face of part
KIT NUMBER:      
      
WORK HOLDING:  SOFT JAWS  CHUCK PRESSURE:  
GRIP LENGTH:  0.0267  TAILSTOCK PRESSURE:  n/a
SPACER LENGTH OR T#:  n/a  SPACER LENGTH OR T#  n/a
      
      
Restart #               TOOL NO.: Offset# OPERATION: Tool Description Capto Insert Length
      
N007 1 1 ROUGH FACE C4-DCLNR-27050-16 Y CNMG-432
      
N181 5 5 ROUGH BORE R571.35C-403227-15 Y DNMG-432
      
N016 2 2 FINISH FACE C4-DCLNR-27050-16 Y CNMG-432
      
N025 7 7 FINISH BORE R571.35C-403227-15 Y DNMG-432
      
N074 11 11 FINISH WEB C4-TLSL-27050-3 Y TLR-3094R
      
N105 9 9 GROOVE C4-TLSR-27050.3 Y TLG-3142L

---

Reply from Alex Hedley:

I've done something similar with REGEX with a HTA. Take a look at the link and let me know how you get on