Data is an important and valuable resource for many businesses, but there is a lot of data available. Many interactions with data are to perform analysis and format it to make it easy for humans to digest and utilize. As a database application, 4D will typically have a lot of data available. A tool that many use to work with data is a spreadsheet application. A common spreadsheet application is Microsoft Excel. To connect 4D to Microsoft Excel, the ODBC API is typically used. However, ODBC is becoming outdated with many other options becoming available with modern technology. This Technical Note will provide a guide on an alternative method to connect Excel to a 4D Database using the 4D REST API. This will allow Excel connections to be made without the need to install the ODBC Driver while live data can be pulled from 4D. A sample database with the code and configuration examples is also provided.

Download Complete Tech Note: Tech Note Document