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

You could use Environment.NewLine to get what the current OS's newline is, but that wouldn't help you parse DOS text files when running on UNIX or vice versa. Personally, I don't see what's so bad ...