Posted by Marc on July 11, 2005 at 10:04:27:
In Reply to: Re: ODBC/EXCEL posted by Stephen Auerbach on July 11, 2005 at 09:50:59:
Much of the code is for the LTSRTNS.inc use file where I include all of my excel csv stuff. If you look at the ADDAMT sub routine, I feed it a numeric and I return a string with a leading sign followed by the absolute value of the amount. This result is then added to my output string without quotes. Don't know whether this is better than doing it the way you do it, I just know that I've been using these routines for many years with good results. Also, some of the logic I included was to create the header record for the .csv file, and then another routine for the detail.
also, I have a routine that I include when I use the reporter called SENDTXT. After I generate a .csv file using the reporter, I end with a RUN SENDTXT,,"xxxxxx.csv,txt" statement. My SENDTXT program [1] check to see if it was run using comet anywhere. If so it transfers the result to the local machine. [2] I then do a PATH routine and tell the operator the entire path including the file name where the file can be found (ie: c:\excel\xxxxx.csv) and ask the operator if they want to launch excel. [3] If they do, I launch the xxxxx.csv file. Clients seem to like. If you want, I can forward to you also.