Hello, I'm working on a project where I must export to a text file and the text file needs to be formed into columns so that it can be imported into a WORD mail merge document.
So, the format of the output file has to have the headers for each column and the lines must have a CR at the end of each line in order to keep the columns formatted. Here is what I'm doing now: select created, status,user, comment1, comment7, comment8, trouble from tbl WHERE customer = 'customer' AND created BETWEEN '2004-05-31' AND '2004-06-25' ORDER BY created, status into outfile 'test5.txt' fields terminated by ',' optionally enclosed by '"' escaped by '\\'; All the lines run together so it makes it impossible to import. Thanks in advance for your help. Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Please report errors to [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~