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 least ...

This guide explains how to change the file extension in Windows 11. It also clarifies the distinction between file extensions and file types. Change a File Extension the Easy Way The simplest way to ...