We use FMP as our CRM and I'm trying to extract data directly into Excel. I have a DSN set up.
Via Excel if I 'Get External Data' via ODBC I can see a preview of the data within the table I want to query against. (If I go to Edit this in Query Edit I can see the full data set)
However, as soon as I try and use SQL statements the field headers populate into Excel but no results are brought back. This is the same if I use MS Query. I have used the SQL statements produced by MS Query to ensure there are not any issues there.
Any help would be greatly appreciated. I feel like I'm so close but just can't get to the data the way I need to.