I have an Excel spreadsheet that uses ODBC to import data from MS-Access database.
In Excel, I can refresh the worksheet to pick up the latest changes that I have made to the Access database.
I'm not sure how to do the same with lazarus spreadsheet component, can anyone advise, is there a "refresh external data" method available, or maybe I need to change flags in the Excel file or lazarus components?