Append text to access using ITC and TransferText- end of line not recognized
I am attempting to append data from an ftp server to my access database. I am using the internet transfer control to retrieve a text file from the ftp server to a local directory. The text file contains no headers and I am trying to append it to an access table using the transferText command.
the file downloads fine and i can open it using excel or notepad however when i try to import it to access (either manually or using VB) the end of line characters are ignored and access tries to import the contents of the entire file as a single field.
The ftp server is in a unix box and i am downloading the file to a NT machine. could it be that the text file is in the wrong format? Is the TransferText command the best way to append this text file to my table?
If anybody can point me in the right direction I'd really appreciate it (plus you get 100 points!) :)