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

Open the Visual Basic 6 compiler application from the Windows "Visual Basic" program group. Open your VB6 project in the editor. Create a file handler to the CSV file.

If the file is located in the same directory as the VB project, you can leave App.Path and just change the name of the file. Press [Ctrl] [F5] to run the project.