Browse » Home
Thursday, February 23, 2012
How to Import Export Excel Text Into Access
Import in Microsoft Access
1. Open the Microsoft Access application on your computer. Click on the 'File' option for Access 2003 or the 'Microsoft Office' button for Access 2007.
2. Click on the 'Open' option and locate the Access database that you want to import and export data into. Select the database and then click on the 'Open' button.
3. Click on the 'File' or 'Microsoft Office' button again. Move your mouse over the 'Get External Data' option and then click on the 'Import' option. The Import dialog box will then appear on the screen.
4. Select the 'Microsoft Excel' option from the 'Files of type' box. Click on the arrow next to the 'Look in' field and locate the Excel file that contains the text you want to import.
5. Double click the Excel file. Click on the 'Import Data into a New Table' option and then allow time for the importing process to complete. The Excel text will then be imported into your Access database.
Export in Microsoft Access
6. Open the Microsoft Access program on your computer. Click on the 'File' option for Access 2003 or the 'Microsoft Office' button for Access 2007.
7. Click on the 'Open' option and locate the Access database that you want use for import or exporting Excel text. Click on the database file and then click on the 'Open' button.
8. Click on the 'File' or 'Microsoft Office' button again. Click on the 'Export' option and then the Export dialog box will then appear on the screen.
9. Click on the 'Microsoft Excel 97-2003' option from the 'Save as type' box. Click on the arrow next to the 'Save in' box and select the folder you want to save your exported data to.
10. Enter a name for your file into the 'File name' box and the click on the box next to the 'Save formatted' field so that it's selected. Click on the 'Export' button and the data will be exported.