Re: Removing an EOF marker in a text file for importation

Hi Karlene,

Windows text files don't normally have or need special terminating
symbols (their size is stored in the directory entry). Anyway, using
Access 2003 I have no problems importing text files terminated with or
including the CP/M-DOS EOF character (\x1A), and the Unix equivalent
(\x04) seems to be treated as an ordinary character.

So I'm not sure what you mean by "the EOF marker", or what sort of text
files you are trying to import. Can you give some more details?


On Mon, 9 May 2005 07:33:11 -0700, "berybery"
<berybery@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hello,
>I'm using ACCESS 2003.
>
>Whenever I try to import a text file into ACCESS, the sample display in the
>Import/Export wizard shows me garbage. If I remove the EOF marker in the text
>file it comes into ACCESS nicely.
>
>Is there a way for ACCESS to remove the EOF marker for me, without me having
>to do it manually?
>Thank you,
>Karlene

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Loading