[AccessD] ftp and access

Pedro Janssen pedro at plex.nl
Fri May 7 09:02:34 CDT 2004


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