Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to export a query to a Excel worksheet
Message
 
To
02/12/1996 16:48:23
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00013917
Message ID:
00014121
Views:
50
>>Hi Dave:
>>
>>>if query builder, this is one of the destination options. if SQL, save to temporary table and export cursor to excel
>>
>>The query builder of VFP 3.0b, doen't have that destination option.
>>
>>How can I export the cursor to excel from a VFP aplication
>
>Use the COPY TO syntax. You have a variety of export formats available.

In reading the various replies to this message, it occurred to me to turn the problem around. Rather than exporting to an Excel worksheet, Excel supports using Microsoft Query to access the data. This is done via "Get External Data" or in building a pivot table.

What version of Excel are you working with?
Edward Johnson
Previous
Reply
Map
View

Click here to load this message in the networking platform