Hi Mukesh,

Thanks for using Community Hub.

I'll leave this thread open for members with experience of this to comment, but the following articles may be useful:

Link to your data in Microsoft Excel using ODBC >

Link to your data in Microsoft Excel using ODBC on a 64 bit computer >

Once linked, most users then use a pivot table to summarise the data >

If this helps, please click Verify Answer.

Regards,

Andy
Sage UKI