How to Open an Access File Using Excel from the Public Data Website (Data.nysed.gov)

1. Download the ZIP file from the Downloads link on data.nysed.gov.
2. Extract files from ZIP file.
3. Open a blank workbook in Excel.
4. From the blank Excel document, click File > Open and use browse navigate to where you extracted the files from the ZIP folder.
5. In the lower right corner, change ‘All Excel Files’ to ‘All Files’ and select the Access file.

6.Select the database you’re interested in reviewing. The default import setting should provide what you need.

Select how you want to view data in your workbook: Table Where do you want to put the data? Existing worksheet Click OK.