If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Text Export needs CR/LF at end - how to??
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. |
#3
|
|||
|
|||
Text Export needs CR/LF at end - how to??
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. |
#4
|
|||
|
|||
Text Export needs CR/LF at end - how to??
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. |
#5
|
|||
|
|||
Text Export needs CR/LF at end - how to??
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. |
Thread Tools | |
Display Modes | |
|
|