I have successfuly imported data from Excel into my Delphi application except with a particular worksheet where the data was populated by macros within Excel. The recordcount in the clientdataset is zero after I try to import from Excel.
If I copy/paste the data to another Excel workbook, it imports fine. If I copy/paste the data back onto itself, it will not import.
It seems weird that the presence of the macros could interfere with the import process.
Any suggestion how I could make the import work?