Database query for Excel

Database query for Excel is a built-in function of Microsoft Excel. It is available from early versions of Excel. Once I started to use it, I found this function to be very powerful. It can be used for almost all queries you are running under Query Manager. The format of the report can be done quickly and attractively. To me, it is an alternative to a simple Crystal Report.

The screenshots in the book all come from Excel 2003. If you are using Excel 2007 or higher, you may need to from a similar menu but not an identical user interface. The functionality has no significant changes.

Import External Data is the menu item you need to locate. It is under the Data menu. The first thing to do is to create a New Database Query ...

Get Mastering SQL Queries for SAP Business One now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.