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

If you have a list of items in a text file and you want to import data from a text file into Microsoft Excel, you can do that without writing them manually. An option in Excel allows users to import ...

If a program can output a delimited text file (I’ll get to what that means in a minute), Excel can turn it into a reasonable table. Of course, the text has to be properly prepared. Every line in that ...