Turns out the text file was indeed saved on a UNIX machine. So Steve Medvid you were correct, even though I did have to figure this out through trial and many errors :).. but all is well.
I just downloaded Textpad 4.0 and opened the text file and did an immediate F12 save as.. and changed...
I have a .txt file that i'm trying to import into Access 97 and it is delimited by -|- (that's shift \ above the enter)
I have 132 fields then a carriage return at the end.
The problem being, when I import more than one line of text, access doesn't recognize the carriage return and start a new...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.