How to Parse an Excel Spreadsheet in Access
Both Microsoft Access and Excel work together to contain your data and display it in spreadsheets and reports. To parse data in Excel from Access, you create a link to the Excel spreadsheet. Linking to the spreadsheet lets you view the data, import it into Access and use it in your Access reports. You can also export your Access data to the Excel spreadsheet.
Other People Are Reading
Instructions
-
-
1
Open the Access database. After the database loads, click the "File" menu item at the top. From the list of options, click "Get External Data." Click the "Link Tables" options.
-
2
Click "Microsoft Excel" in the "File type" drop-down box. When you choose "Excel," several other configuration text boxes display.
-
-
3
Click the "Browse" button to select your Excel spreadsheet. Click "OK." Microsoft Access creates a connection to the Excel spreadsheet. On the right side, choose the sheet to which you want to link. The default selection is the first sheet in the spreadsheet.
-
4
Click the "Next" button. Review the spreadsheet information to verify that the data is what you want to link. Click "Finish" to link to the data. The connection wizard closes.
-
5
Click the "Tables" icon in the Access menu. Double-click your spreadsheet name in the list of tables. The spreadsheet opens and parses in your Access window.
-
1
