Select delimiter in .txt creation

C

Chartsmalm

I need to send an Excel file to a system that expects text with ASCII 124 ['|'] as the delimite. Can the delimiter be changed from the tav in excel. I passing thru Access, where one has control of the delimiter, but Access made to many changes to the formatting of my data.
 
T

Tom Ogilvy

Chip Pearson has written code that allows you to write a text file (csv
style) and specify the delimiter.

http://www.cpearson.com/excel/imptext.htm

--
Regards,
Tom Ogilvy


Chartsmalm said:
I need to send an Excel file to a system that expects text with ASCII 124
Click to expand...
['|'] as the delimite. Can the delimiter be changed from the tav in excel.
I passing thru Access, where one has control of the delimiter, but Access
made to many changes to the formatting of my data.
 
Top