Hi there, I am having a problem with a text file that I'm trying to import into access. Basically I have a dowloaded file from another computer system that is a text file.
The problem that I have is that the text is formatted in one straight line so therefore Access will not import the data into a table.
I am wondering if there is a way for me to go in and enter a "return" every 60 characters. This way my data will line up in columns like I need, as opposed to one row of data that goes on forever!
The problem that I have is that the text is formatted in one straight line so therefore Access will not import the data into a table.
I am wondering if there is a way for me to go in and enter a "return" every 60 characters. This way my data will line up in columns like I need, as opposed to one row of data that goes on forever!
