Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't print Excel file created with COPY
Message
 
 
To
30/12/2013 12:22:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01591089
Message ID:
01591105
Views:
77
>>Try adding NOFILTER in your select statement and TYPE XL5. Also, did you verify that the file contains data?
>
>Changing to XL5 fixed the problem. I did not have to type NOFILTER. Thanks!
>
>Interesting - the XLS worked on my machine (Win 7), but not on the other (Windows Server 2008 R2 Standard).

NOFILTER is a must in your situation because you're selecting all the columns and using a where condition. It may result in the filtered result.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform