vba

I am a VBA developer and trying to get the Output of a report from JDE to Excel through ODBC. I am able to connect to JDE using New Query option in Excel and I can see the tables but unable to find the data I am looking for. We run a Gain and Losses report and then extract the report through...