[AccessD] ftp and access

Gustav Brock gustav at cactus.dk
Fri May 7 09:15:52 CDT 2004


Hi Pedro

Sounds like a problem with new lines (Carriage Return and/or Line
Feed) - both should be present when the file is used in Windows.

Check if the FTP client has some settings for these.

/gustav


> Hello group,

> for some reports, i import txt-files in access with data of our hospital unix system. These txt-files are made from the unix data with an FTP client server that is present in Reflection emulation
> software for windows. I choose to make it txt files with an ftp server because of the advantage of transporting the file to the windows system and making ASCII textfiles from them can be done in
> one action (clicking a button with Vba code behind it). The file in unix is in delimited space between the columns and normally after the ftp transfer these columns in the txt-file still exist, so
> that i can use import -specs in access to import them. But suddenly after the ftp transfer, the columns in the txt-file don't exist anymore. Al the records are placed behind the other. Nothing has
> changed in the Vba code with the transfer. 

> I know this isn't a ftp forum, but maybe anybody experienced this behaviour before?

> Pedro Janssen
> Cytologist




More information about the AccessD mailing list