I would like to take an existing text file (approx 4 megs in size) and manipulate it with VB or VBA (from inside Access in that case) and then ideally place it inside a table format, at the very ...

One of File Explorer's largest limitations is the inability to remember tabs or open preselect pages. This simple script will help you fix that and open several File Explorer tabs upon launch.