Importing/ Exporting text file from Unix

[silvia]

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]

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

 

[Brendan Reynolds]

The URL below links to a response I posted in the past to a similar
question.

http://www.google.com/groups?selm=%[email protected]

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.