Text Export needs CR/LF at end - how to??

Using Access 03 - Exporting table to Text with ~ delimiter. Receiving system
is Unix and requires CR or LF to separate the records as it reads - currently
it reads the 1000+ records as one.

Try adding a calculated field to your query that is the CR character:

MyCR: Chr(13)

--

Ken Snell
MS ACCESS MVP

"willjs" wrote in message
news
Using Access 03 - Exporting table to Text with ~ delimiter. Receiving
system
is Unix and requires CR or LF to separate the records as it reads -
currently
it reads the 1000+ records as one.

my query is simply a Select (records) ... from (table) statement.
how exactly would i add this?
i am not a SQL expert

"Ken Snell (MVP)" wrote:

Try adding a calculated field to your query that is the CR character:

MyCR: Chr(13)

--

Ken Snell
MS ACCESS MVP

"willjs" wrote in message
news
Using Access 03 - Exporting table to Text with ~ delimiter. Receiving
system
is Unix and requires CR or LF to separate the records as it reads -
currently
it reads the 1000+ records as one.

Open the query in Design view. Go to the first empty column, and click in
the Field: cell. Type this:
MyChar: Chr(13)
Be sure that the "Show" checkbox is checked to "yes".

That will write a CR character as the last value in each row.
--

Ken Snell
MS ACCESS MVP


"willjs" wrote in message
...
my query is simply a Select (records) ... from (table) statement.
how exactly would i add this?
i am not a SQL expert

"Ken Snell (MVP)" wrote:

Try adding a calculated field to your query that is the CR character:

MyCR: Chr(13)

--

Ken Snell
MS ACCESS MVP

"willjs" wrote in message
news
Using Access 03 - Exporting table to Text with ~ delimiter. Receiving
system
is Unix and requires CR or LF to separate the records as it reads -
currently
it reads the 1000+ records as one.

If you're using TransferText to export the table, it automatically uses
CRLF (\x0D0A) anyway.

But in Unix the standard newline is just LF (\x0A), so maybe it's the
CRs that are causing the trouble. Try filtering them out of the file: a
web search for something like
convert text windows unix
will find a variety of utilities that can do this.

If the Unix system parses the filtered file correctly, include the
filtering in the regular workflow (with luck it will just mean adding a
line to a shell script on the Unix side, or you can do it in Access
VBA).


On Sat, 24 Feb 2007 18:43:05 -0800, willjs
wrote:

Using Access 03 - Exporting table to Text with ~ delimiter. Receiving system
is Unix and requires CR or LF to separate the records as it reads - currently
it reads the 1000+ records as one.

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.