Best method for a text import is create a ????.txt file in a folder.
Then within MS Access import this txt file. During the first step of import process - Click the "advanced " button. This will bring up an import specification screen. Within this (Using either "Delimited" or "Fixed" setting )...