Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems on second spreadsheet
Message
From
12/03/2002 06:22:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
11/03/2002 11:19:31
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00630925
Message ID:
00631388
Views:
24
>Hilmar,
>
>What are the reasons that you use automation instead of APPEND FROM XLx? Were you experiencing problems with APPEND FROM or do you have to deal with special formatting? I have had occasional problems with APPEND FROM XL5/XL8 with certain spreadsheets. I was never able to know the exact reason, but had the impression it was linked to some accented characters.
>
>Maybe you could save the spreadsheets as CSV or DBF and use APPEND FROM?

Thanks; I was already considering this: the old format was not appropriate for "save as DBF", but the new format can easily be copied to DBF. But still, I am concerned that automation doesn't always seem to work - I thought I could use it for an almost arbitrary format, where "save as DBF" doesn't work.

And it doesn't make much sense to me that the first automation works, and the second fails.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform