>Thanks for the suggestions. I knew about the OLE Automation route, but I wanted to know if I was missing anything concerning the EXPORT TO command, or if there was another VFP method used for pushing data into Excel.
>
>Ben Holton
Unless you are only pushing a small amount of data into Excel, using pure OLE automation is painfully slow.
Instead, I have found it more efficient to:
1) make a CSV file using COPY TO output.csv DELIMITED
2) Start Excel using OLE automation
3) Make Excel open the output.csv file via OLE
4) Insert a row at the top and populate the cells with column titles via OLE
(note this allows you to make better column titles then field names anyway)
5) Perform other formatting such as fonts, alignments, borders, shading,
sheet names, etc. via OLE
6) Save the data as a Excel Workbook via OLE
If you want some examples, please let me know,
David