Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving to DBF3 with Excel automation
Message
 
To
09/03/2005 09:20:11
Salminen Jukka
Js Software Systems
Vaasa, Finland
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows NT
Miscellaneous
Thread ID:
00993977
Message ID:
00993987
Views:
24
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform