Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from Excel oddity
Message
From
03/07/2008 13:01:00
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01328371
Message ID:
01328758
Views:
14
>AFAIK, Excel import is bult into VFP and doesn't use any external components.
>Are you 100% sure that you're referencing the same file in all cases?

Absolutely. The first thing the program does is bring up a screen with a text box and a button to locate the xl file to use. Internally it uses GetFile(), and we both go to exactly the same file. GetFile() fills the gcClaimFile variable and that's what is used in the append from line.

Oh well, I guess I'll have to try loading the xl file the hard way. Column by column; row by row. That takes so long to run, but at least I've never seen it fail.

>
>>Well, I did that, and lo and behold, it's telling me that the excel file format is invalid (error 1661). This makes no sense at all. It works for me on the same excel file (the file is on the network, and we both point to it). Also, when he types the line manually into 'x-ray' (the command window type program), the excel file loads very nicely.
>>
>>This is way bizarre. We both have the same excel odbc driver and the same installation of excel. I have full vfp9 and he has vfp9 runtimes.
>>
>>Any thoughts? I'm baffled.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform