Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

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

Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.