Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from Excel oddity
Message
De
03/07/2008 13:01:00
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01328371
Message ID:
01328758
Vues:
16
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform