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

Microsoft Excel's implementation of Visual Basic for Applications, or VBA, helps you record or write macros that turn sequences of tasks and commands into pieces of one-click automation. Macros can ...