[AccessD] ftp and access

John Frederick j.frederick at att.net
Fri May 7 09:15:07 CDT 2004


This doesn't sound like an FTP problem.  Either the code creating the txt
file is leaving out column delimiters or the CRLF or your import spec is
looking for different delimiters.  Try opening the txt file using Notepad to
see what it looks like.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen
Sent: Friday, May 07, 2004 10:03 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] ftp and access


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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list