>Excellent! Thank you, Hilmar.
Well, actually, there is another alternative, faster to program, which I use sometimes. Use SELECT to rename fields, and then copy to Excel. However, you can't include spaces, etc., in field names. Automation gives you the greatest flexibility.
Sample of the above:
select field1 as Long_Field_Name_1, field2 as Long_FieldName_2;
from MyTable;
into cursor Temp
copy to Temp.xls type xls
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
