Here there is a sample for both.
http://www.foxite.com/archives/archives/0000153776.htmCetin
>Hi Cetin.
>Can you point me in the right direction with ADO?
>Thanks!
>Tony
>
>>FWIW do not use import/export commands with Excel. Use ADO instead.
>>Cetin
>
>>>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!
>>