>I'm working with a database that has field names that aren't the greatest in the world. I'd like to export on a filter condition or two to an excel file, however, when I do the field names are on the columns. Well I understand why that is, but I'd like to change that, so that the column names are more user understandable..(ie. User Address, instead of useaddr) Is there a way to do this? I've looked at using SELECT - SQL to do the query and then export a cursor to a file, but that isn't an option with the export command. Is there something I can do with EXPORT to tell it to use different column headings? Or should I be looking at a whole different approach? I look forward to you wisdom;)
Probably not the most elegant solution, but one I have used is to do a SQL SELECT on the table you want to export into a cursor or table using AS clauses to give new field names, e.g. Field1 AS Last_Name, etc. Then you can EXPORT or COPY TO from the created cursor or table. Just one possibility.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.