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