Hi Naomi,
I may have to use both methods then. I'll just use ADO to get the sheet names, then OLE DB for the rest.
Regards,
Arriyel
>>Hi Naomi,
>>
>>Thanks for the reply. Been trying to find info on OleDbSchemaGuid which is a part of the following line of code that retrieves the sheet names:
>>
>> oXLSConnect.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, NULL)
>>
>>
>>Regards,
>>Arriyel
>>
>
>It's .NET class, so I'm not sure how to use it from VFP:
>
>
http://aspalliance.com/631>
>BTW, again the problem with NULLs from MSKB you mentioned was recently brought up here in one of Michel's thread in .NET forum.
Weird Excel import into a dataset Thread #
1202088
Speak using soft and sweet words in case you have to eat them later.