GetOleDbSchemaTable: Exclude named ranges from Excel
 

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

GetOleDbSchemaTable: Exclude named ranges from Excel
 

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

GetOleDbSchemaTable: Exclude named ranges from Excel
 

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

GetOleDbSchemaTable: Exclude named ranges from Excel
 

ADOX should work

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

DM Unseen