Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to Excel data format problem
Message
From
09/01/2001 11:40:14
 
 
To
09/01/2001 11:38:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00461214
Message ID:
00461221
Views:
9
Huh, what? OK....explain this whole thing in a bit more detail. I think there is a solution to your problem but the problem is vague :-)

>Looks like it is probably ODBC...then there is a 'DO Excel WITH...' call which is when Excel actually opens.
>
>
>>How are you "saving into Excel"?
>>
>>>I have a FoxPro table that I am saving into Excel. Some numerical fields in FoxPro have to be set as Char to allow the correct amount of decimal points to show. When this data is saved into excel, it does not allow you to format the fields to change them to number so that analysis may be done. The only way to change them is to edit every field. I can't seem to figure out why it won't allow me to change the formatting. Something seems to be holding the char format in Excel.
>>>
>>>Any ideas?
>>>
>>>Thanks!
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform