Foxpro is a database has existed for many years, it support risk function to query data. In Excel you can connect to Foxpro Database by Add-in A-Tools. Please do step by step:
1. Download and Install Foxpro ODBC Driver here
+ For Office 32-bit
https://uofi.app.box.com/s/uq7ot6guyc8wey7nbvfxgt0eeixjbwv5
+ For Office 64-bit
May be not run ?
Download and install it very easy! "Next" to Next ... Finish.
2. Install Add-in A-Tools
3. Open Microsoft Excel, go to menu "A-Tools".
+ Click on "DBKEY", "Add", select "MS Visal Foxpro (VFP)" from menu.
- Select folder that has Foxpro database or tables (*.dbf), click button "Ok"
.png)
Video:
+ Create DBKEY with name "FOX" (you can create name by optional)
4. Query data from Oracle database in our server (bluesofts.net)
Type formula on worksheet
=bs_Sql("SELECT * FROM KHO","dbkey=fox")
Video help connect to Foxpro and create report Excel having grouping as subtotal