Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save Large Tables in Excel Format
Message
 
To
01/07/2005 11:23:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01028183
Message ID:
01034867
Views:
23
I have Excel97 at work and it can open a file made with:
COPY TO myfile.xls TYPE FOX2X
Note the extension. This allows you to double-click on the file in windows Explorer and bring up Excel by association!

Dana


>>Thanks for your quick reply.
>>
>>How do I get the fields to go into separate columns automatically.
>
>Sorry, I didn't notice the part about all the data being in Column1. However, I have opened comma-delimited files and they were split successfully. I am not sure what is going on. Perhaps you should explicitly give the CSV extension.
>
>One alternative would be to use the "parse" option in Excel.
>
>Another would be to switch to DBF format instead of CSV. From VFP:
>
>
>copy to temp.dbf type foxplus
>
>
>FoxPlus is the dBASE III format; Excel can't read VFP tables directly.
Where's the damned Any Key?...too late
Previous
Reply
Map
View

Click here to load this message in the networking platform