Hello everyone.

I was wondering if anyone in the community knows if it is possible to query an ".xls" file that is in either "XML Spreadsheet 2003" or "Web Page" format. A vendor exports ".xls" files either in XML or HTML and causes an issue with my ADO code.

Is it possible to ADO either of these 2 types of files via code from Excel? The error message I receive is "Run-time error '-2147467259 (80004005) External table is not in the expected format".

Thank you.