AnsweredAssumed Answered

ODBC & Microsoft Query issue

Question asked by ohigenbottam on Jul 25, 2018
Latest reply on Jul 25, 2018 by ohigenbottam

Hi all,

 

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.

 

Thanks

Outcomes