If you are getting the following error:
Error (Error (Exception from HRESULT: 0x800A03EC,
(COMException Error code:0x800a03ec)) while nnnn Records
Selected
Writing Record Data for <xxx> to Data Worksheet, 1 of 1.
Data Sheet will not contain rows for <xxx> in workbook <xxxxxxx>) while Loading Record Data in
workbook <xxxxxx>. Data Sheet has not
been changed.
Then yry opening a new empty workbook and try the Access INXL Get Data and or Get Detailed Data functions in a fresh workbook.
If this works, then it may be an issue in the existing workbook.
If it is practical to do so, then work using the newly created workbook rather than the pre-existing one that had the error.