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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.