Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing from Excel
Message
From
16/06/2008 16:40:19
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01324504
Message ID:
01324556
Views:
21
Hi.
For me the
IMPORT from c:\test TYPE XL8 SHEET [Sheet1]  &&& first sheet
BROWSE
IMPORT from c:\test TYPE XL8 SHEET [Sheet2]  &&& secondt sheet
BROWSE
does not work. It returns allways data from the Sheet1.
I don't know if its related to Portuguese version of Office that
I'm using or if it's a problem with the file.
I'm going to make some more tests and let you know later.
Thanks a lot!


>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
>
>>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!
***
TONY Nascimento
*****************

"Your mind is like a parachute. It only works if it is open" - Anthony J. D'Angelo

"The desire to know is natural to good men" - Leonardo da Vinci
Previous
Reply
Map
View

Click here to load this message in the networking platform