Exporting Data to Microsoft Excel

You may need to get data out of a Sage 100 Contractor report, Quick Report, Quick Grid, or Find query and into a Microsoft Excel spreadsheet so that you can add to or reorder the data or combine data from different reports into one document.

In some situations, a grid may be displaying too many columns to be viewed in the Print to screen viewer or to be printed, even in landscape orientation. It is just situations that exporting to Microsoft Excel provides a solution. Microsoft Excel has the capability to capture all the data on any grid in Sage 100 Contractor.

The exported data includes the following information:

• Company name
• Report title (grid or query name)
• Selection criteria
• Column headers
• Labels
• Data
• Formulas
  
• User name
• Report number (for example, 3-5-0-21)
• Date and time

The exported data excludes the following information:

• Graphics, lines, double lines, boxes
• Pagination
• Checks

To export report data to Excel

1

From a main window, for example 4-2 Payable Invoices, on the toolbar, click the Print Records button.

2

The Report Printing window opens.

3

Select a report that you want to export to Excel.

4

Click the Send report data to Excel button.

5

Your computer launches Excel with a new worksheet populated with the report data.

To export Quick Grid data to Excel

1

Open a Quick Grid window.

2

On the toolbar, click the Print Records button.

3

The Report Printing window opens.

4

Click the Send report data to Excel button.

5

Your computer launches Excel with a new worksheet populated with the quick grid data.

To export Find query data to Excel

1

Open a window that supports Find queries.

2

The Query List window opens.

3

Select a query, and click Run.

4

The Run Query window opens.

5

Enter criteria, and click Run.

6

Your computer displays a quick grid populated with the query data.

7

On the toolbar, click the Print Records button.

8

The Report Printing window opens.

9

Click the Send report data to Excel button.

10

Your computer launches Excel with a new worksheet populated with the selected data.