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

All you have to do is pass a pathname for the file or files as a string expression to the function—for example, Kill (App.Path & “\1.txt”) —and the files are deleted. But if you want to give your ...