I use the typical dde.ini file where the export to excel is done with "Format=TAB".

However large text fields (like Incident Notes) sometimes have embedded tabs, and this mucks up the columns in excel.

If I do an 'export to file' with a CSV format, then open the file in Excel: things work fine.

I tried a simple change to the dde.ini and put in "Format=CSV" but I just got the entire csv file dumped into the first column.

Any advice on how to use CSV instead of TAB in the dde.ini (or other advice on how to make the export run cleaner)?

thanks
 -ivan-

--
Ivan Runions
  3rd Party Services Support
  Information Technologies
  University of Calgary
  Calgary Alberta Canada
  (403) 220-4437

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Reply via email to