Microsoft Query Download For Mac

Posted onby

Introduction

Microsoft releases Mac OS X-only Query. At Microsoft has released Query X, a Mac OS X-only product that lets you import data from databases into Excel X via Open. Query is a 2MB download. SQL Server Express Question 4 10/8/2012 12:51:14.

Microsoft Excel for the Mac includes the ability to import live data from a database using an ODBC connection. This tutorial will describe how you can import sales data from an on-line salesdatabase into your Excel spreadsheet. Once the data is in the spreadsheet, you can use Excel toperform further analysis of your sale data.

These instructions assume you have already downloaded and installed the appropriate ODBC driverfor your database and you have configured a DSN (data source name). If youhave not yet purchased a license key, you will onlysee the first 3 rows from any database query.

Please contact us at [email protected] you have any questions or suggestions regarding these instructions.

Connecting to your sales database

Let's suppose you want to see how many products you are selling, according to category and country. Thereare many different shopping cart databases you might be using (such as osCommerce), but they all havesimilar tables defined for storing customer, product, and sales information. We will use the NorthWindexample database, whose defined tables should map easily to your own database tables. Please contact usif you have any problems using the tables in your database.

In this example, we will start with a new spreadsheet, although you could import your data into anexisting spreadheet if you wanted.

Start Microsoft Excel and select File->New Workbook from the menu. Position your cursor in cellA1, and select the Data->Get External Data->New Database Query...

When the 'iODBC Data Source Chooser' dialog is displayed, select the DSN you configured previously and press OK:

After you enter your database's user ID and password (if needed), you will see the main window for Microsoft Query. MS Query is included with Microsoft Office 2004 (a separate download in MS Office X),and is used specify the information you want imported into Excel. One of the Windows will includea list of tables defined in your database:

For our report, we will select the following tables one at a time and press the 'Add Table' for each one:Categories, Products, Orders, Order Details, and Customers:

The tables we have selected are related to each other. For example, the Categories table andthe Products table are related to each other by the fact that they both contain a field named CategoryID.We need to link the tables together by drawing a line between the related tables (this is known as a 'join').

When we drag a line between one table to the related table, MS Query will display a dialog like this:

For this example, we will just accept the defaults and press OK.

After we have drawn the links between the tables, the next step is to specify the fields from each table thatwe want to appear in our results. We add a field to our results by double-clicking the field name within the table:

We'll then go ahead and select the following columns:

Microsoft Query Excel

Now that we've specified the columns that will appear in our results, we can try out our query bypressing the 'Test!' button. If there is no error in our query, we should see the records that willbe imported into the spreadsheet:

Once we're satisfied with our query, we press the 'Return Data' button in the lower right cornerof the window to import our results into Excel. Excel will then prompt us for the location to place the results:

We'll just accept the default and press OK. The results are then imported into the spreadsheet:

Once the data is in your spreadsheet, you can perform all the functions on the data supported byExcel, such as summation. You can also re-run the query by right-clicking on your results and selectingRefresh Data:

Microsoft Query Download Mac

For more information

To learn more about the Excel database connectivity, please visit our MS Office Resource Center.




  • Download
The program can not be downloaded: the download link is not available.External download links have become invalid for an unknown reason.Sorry, but we cannot ensure safeness of third party websites.
Microsoft windows for mac download

Often downloaded with

Microsoft Query Download For Mac Free

  • Microsoft Edge CanaryMicrosoft Edge Canary is a Microsoft Edge Insider Channel that makes it easy to...DOWNLOAD
  • Microsoft TeamsMicrosoft Teams is the chat-based workspace in Office 365 that integrates all...DOWNLOAD
  • Microsoft PlannerMicrosoft Planner provides a simple, visual way to organize teamwork. The...DOWNLOAD
  • Microsoft To-DoMicrosoft To-Do is a simple and intelligent to-do list that makes it easy to...DOWNLOAD
  • Microsoft ExcelExcel for Mac 2011 helps you analyze, organize, and manage all your data and...$119.99DOWNLOAD