Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing from Excel
Message
 
To
16/06/2008 15:04:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01324504
Message ID:
01324514
Views:
23
>Hi.
>I'm using VFP9 SP2.
>When importing an Excel 2003 file with multiple sheets
>using IMPORT FROM i only get data from the sheets other than
>the first one if I specify TYPE XL5.
>Is that normal for Excel 2003 files?
>TYPE XL8 shouldn't be "more compatible" with Excel 2003?
>I'm just curious.
>Thanks in advance!

I haven't problem with this
IMPORT from c:\test TYPE XL5 SHEET [Sheet1]  &&& first sheet
BROWSE 
IMPORT from c:\test TYPE XL5 SHEET [Sheet2]  &&& secondt sheet
BROWSE

IMPORT from c:\test TYPE XL8 SHEET [Sheet1]  &&& first sheet
BROWSE 
IMPORT from c:\test TYPE XL8 SHEET [Sheet2]  &&& secondt sheet
BROWSE
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform