The export of data from MS Access to MS Excel spreadsheet is usually done on the query results. The results can be appended into the original research data spreadsheet by adding a new worksheet for the summary. One way of exporting the data is by using Copy and Paste.

It is a good practice to count first the number of records that are required for export to make sure that all the records in the query result will be exported into the spreadsheet.

Steps for exporting data into MS Excel

1. Open the MS Access data needed for export. Highlight all the records by clicking the top-left square. Right-click selection and Copy.

• In the example summary_bmi query result, there are 8 records.

2. Go to the MS Excel worksheet and click on the first cell. Right-click and select Paste.

• In the example spreadsheet, the summary_bmi query result will be placed in the worksheet beside the research data. The worksheet is named summary.

• After pasting, double check the number of records exported, and Save the exported data into the spreadsheet.

Please take note that there might be differences between the precision of the data values in the MS Access query (or table) and the exported data in the Excel spreadsheet. To get the same data precision, the Excel data must be formatted in a way, such that it has the same number of decimal places as the data in MS Access.