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

Click here to load this message in the networking platform