Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement