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

How to Automatically Convert an Excel File to Text Using Visual Basic. Microsoft's ubiquitous spreadsheet application, Excel, is a useful tool for small and large businesses alike.

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