This Tech Tip will show how access the 4D database in Microsoft Excel. To do this, a data source (DSN) will need to have been created using the 4D ODBC driver and the 4D database will need to have the SQL server running to be reachable.

It is recommended to use Microsoft Query instead of the ODBC Data connection wizard to access data in 4D from Excel. This is because the ODBC connection wizard tries to ask for a SQL catalog which is not implemented in 4D.

1. In MS Excel, click on the "Data" tab and select Get Data > From Other Sources > From Microsoft Query
   


2. In the dialog box, select the DSN
   


3. Then select tables and fields to import
   


4. This dialog allows you to query the records to be imported
   


5. This dialog allows you to sort the data
   


6. Lastly, select the import format