To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

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

Yep, just as you would expect. This works the same way in Excel and PowerPoint as well. Another feature change that seems obvious in retrospect is that Word can now open *.txt files, which many of ...