Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Save Large Tables in Excel Format
Message
 
À
01/07/2005 11:23:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01028183
Message ID:
01034867
Vues:
24
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform