Changes

Access 2000 Data Import Guide

4 bytes added, 16:35, 9 January 2008
/* Import Excel Data into Access Database */
The following lines were added (+) and removed (-):
Go to the File menu, and select Get External Data, then Import.  Now you must select the file to import.  By default, Access is set to import .mdb files, which are other Access databases.  Since we want to import an Excel spreadsheet file, change the file type dropdown to Excel.  Navigate to the directory where the Excel file is stored and select it.   Go to the File menu, and select Get External Data, then Import.  Now you must select the file to import.  By default, Access is set to import .mdb files, which are other Access databases.  Since the goal is to import an Excel spreadsheet file, change the file type dropdown to Excel.  Navigate to the directory where the Excel file is stored and select it.   
Bureaucrat, administrator
16,192
edits