How to rename a field name if I do not know the original field name

[SHANEMAC51]

Hi @SHANEMAC51 will it be possible for your share Excel code for splitting TEXT files.
Originally I tried same thing but later on moved to Access. Am thinking of splitting the files and run in Excel only.
Reason is, am very new to Access and seeking help at every stage.

choose a minimal text engine
1. copy
2. delete except 2-3 entries
3. you can correct almost the entire text, but leave part of it so that you can check the encoding and line
breaks to lay out the file itself, you can archive