text import

[Garry]

Hi
I need to import a comma delimited text file into access.
FINE !, except within each record the text data has a carraige return
entered.
Please help
How do I get around this and is it an access problem or should I be using a
different application to remedy this fault first

thanks in advance
Garry

 

[John Nurick]

Hi Garry,

Since delimited textfiles use a newline (carriage return + line feed in
Windows textfiles) to indicate the end of the record, newlines within
the data present an obvious problem.

Access can normally cope with them if the file is comma-delimited and
each field that contains a newline (or comma) is "qualified" by
enclosing it in quotation marks, e.g.

123,"First line
Second line",456

Quotation marks within the qualified field need to be doubled.

Alternatively, replace the newlines within the data with a tag of some
kind (e.g "<BR>", same as in HTML). Then import the file; and finally
run an update query that calls the Replace() function to replace the
newlines.

Hi
I need to import a comma delimited text file into access.
FINE !, except within each record the text data has a carraige return
entered.
Please help
How do I get around this and is it an access problem or should I be using a
different application to remedy this fault first

thanks in advance
Garry

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.