Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving to DBF3 with Excel automation
Message
 
À
09/03/2005 09:20:11
Salminen Jukka
Js Software Systems
Vaasa, Finlande
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows NT
Divers
Thread ID:
00993977
Message ID:
00993987
Vues:
23
AFAIK, there are some limitations when converting Excel to DBASE format. Try to do the conversion manually from Excel, then you will see warnings and HELP button on the user dialog. Click on this button to see the topic "Formatting and features that are not transferred in Excel file format conversions" in the Excel Help.



>I'm trying to save an Excel97-file to DBF3 like this:
>
>WITH ox.activeworkbook
> .SaveAs(lcFilename, 8)
> .saved = .t.
>ENDWITH
>
>The only problem is that some numeric fields are empty in the resulting table and I have no clue why. Most of the values in the same column are correct. Has anybody seen this before? Of course I have tried every trick I know to ensure that data in Excel has correct numeric format but this doesn't seem to be enough.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform