When extracting Excel worksheet names using GetOleDbSchemaTable, is there a
way to exclude named ranges in Excel from the result ?

I'm only interrested in getting worksheets returned in the table collection.

Any help would be greatly appreciated.

Thanks in advance,
Thomas

Thomas,

see http://support.microsoft.com/default...b;EN-US;257819

there it explains how to get(or not to get) the difference bewteen
names and worksheets., I think the table_type shoud be different for
names and sheets.

DM Unseen

First of all, thanks for your suggestion.

Unfortunately there's nothing in the returned result that can be used to
differentiate them as far as I can tell. Table_type returns "table" for all
:-(



"DM Unseen" wrote:

Thomas,

see http://support.microsoft.com/default...b;EN-US;257819

there it explains how to get(or not to get) the difference bewteen
names and worksheets., I think the table_type shoud be different for
names and sheets.

DM Unseen

ADOX should work

download from: http://www.appspro.com/Tips/WorkbookTips.htm

DM Unseen