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

But if you want to give your users a safety net and make sure that their files are recoverable, you can take another approach. Instead of using the Kill function, have your apps send deleted files ...