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

VB manages files using numbers, that is, you can have file "1" open for reading, file "2" open for writing, file "3" open for append, and so on. The quotes are misleading because the file numbers ...