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

Here is an example line from the file I am reading:<BR><pre class="ip-ubbcode-code-pre">0000000001 Microsoft Office 2003 Disc 1 99.00 MICROSOFT</pre><BR><BR>And here ...

Microsoft's ubiquitous spreadsheet application, Excel, is a useful tool for small and large businesses alike. However, the Excel format is proprietary and some software applications aren't able to ...