Did you try and open it with any other programs on your computer?

The top thread on this Access Forum has VBA code that opens CSV or text files the old fashioned way that you can try to open the file with.