Re: Importing/ Exporting text file from Unix

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 09/09/04 

Date: Thu, 09 Sep 2004 06:57:19 +0100

Hi Silvia,

Unix text files are structured differently from Windows ones. Unix uses
LF character - Chr(10) - as a line break while Windows uses the pair of
characters CRLF - Chr(13) & Chr(10). Access expects the latter and
unless you provide it you're likely to encounter problems.

As I understand it:

-If you use ftp to download the file to your computer the line ends can
be converted en route, depending on the ftp software you're using and
whether you're downloading it as a text or binary file.

-If you use ODBC the issue doesn't arise because Access sees the data as
a recordset rather than as a text file.

-Otherwise you need to ensure that the file has been converted before
you try to import or link it to Access. There are lots of utility
programs that can do this: search the web for something like
        unix windows text converter

On Wed, 8 Sep 2004 18:29:50 -0700, "silvia" <ehsonsg@bnftech.com> wrote:

>I tried to open text file in unix into Access. But it
>gaves me an Error. It says it couldn't access the file.
>And if I try to import the file, it says it is not valid
>account. I heard that there is no way to get text file
>from unix system without using ODBC. is there anyone who
>knows the way? Do we have to use ODBC?
>
>Please help me! 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
Quantcast