Hello Yann,

Since you have GridView, do the following:

• Launch GridView pointing to your Account Payable data
• Create a new View from Adagio Payables
• Select the A/P Transaction History Table
• Select some fields from the table
• Don't create a Filter
• See if anything is displayed.

This will tell you whether there is anything in the file.

Then, create a DSN using either the 32 or 64 bit Administrator, depending on the version of Excel you are using. Place "AP*" in the "Table Selection" field and save the DSN. Use long names.

Launch Excel, Choose Data | From other sources. and select your DSN. Choose AP Transaction history from the list of tables. Make sure the table can be loaded into Excel. This will show whether the connection is working properly.

I just went through all these steps with the sample data on my system with Excel 64 bit and everything worked fine.

I then launched Crystal Reports 8.5 and select ODBC as my data source. The Adagio AP one was displayed. I chose the Vendor Master and Transaction History tables to add.

Worked fine: