The reason here is that data format conversion is according to Microsoft the old way of exchanging data between applications. The new way is to either use automation or ODBC. What are you trying to do that requires that you copy a table into a Excel file before?
Hi Christof - Some users want to grab some report data (I think they're all cursors) into Excel, and do "whatever" with it (save it, fiddle with it, I don't know exactly). I'm new to doing this with Excel, but I thought an easy way would be to:
COPY TO file.xls TYPE XL8
oExcel = CreateObject('Excel.Application')
and open the file.xls in Excel
then user can do whatever they want, almost certainly save it...
Any better ideas?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.