So, I am using query SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml; HDR=YES; Database={filename};', ['MySheet$']);.
Problem, that I have few tables on the same sheet with different structures and comments. How to extract such tables into separate queries? Is the only way to import everything and then try to drill down each table using values (like null)?