Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from Excel oddity
Message
From
02/07/2008 15:16:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Append from Excel oddity
Miscellaneous
Thread ID:
01328371
Message ID:
01328371
Views:
65
My colleague uses a "command window" type program called X-Ray. It's actually pretty good. When he opens a table called 'lossrun' and types:
Append from "W:\import files\June032008.xls" type xl5 sheet loss_run
the xl sheet gets appended into the table just as you'd expect.

When I compile the code into an exe and he runs it, the [same] xl sheet refuses to load. When I run the compiled exe, it works properly for me - again, same xl workbook (on the network).

I don't know if vfp is using the excel odbc driver, but for the record, I checked and he and I have the same odbc driver.

The only real difference in our systems is that I have full vfp loaded and he has the vfp runtimes - both version 9. And it doesn't matter whether I code xl5 or xl8. Both work for me; neither work for him except when he types them directly into x-ray.

Anybody got any ideas what might be going on here?
Next
Reply
Map
View

Click here to load this message in the networking platform