Changing the record delimiter on export

[rwolff]

I was wondering if there is a way to change the record delimiter on export to other than HRt i.e. []Hrt.

 

[sfreeman]

Yes. First, create the export specifications that you need.

Then create your code that selects whichever spec you want.

You can set the delimiter within the Export Specification.

Example:

Function ExportTest()
On Error GoTo ExportTest_Err

DoCmd.TransferText acExportDelim, "Table1 Export Specification", "Table1", "C:\Documents and Settings\YourFolder\Desktop\Table1.txt", False, ""

ExportTest_Exit:
Exit Function

ExportTest_Err:
MsgBox Error$
Resume ExportTest_Exit

End Function

 

[rwolff]

Thanks for the reply.

I was not able to find the Record Delimiter, as opposed to a field delimiter, in the Export Specification. Where can I find the Record Delimiter specification?

Bob