how to import an excel file into access 2003?
Importing Data Go to the File menu, and select Get External Data, then Import (Figure 6). Next, we are prompted to select which file we want to import (Figure 7). By default, Access is looking for Access mdb files first. Change the file type to Excel files, browse to the folder where the file is stored, and select it.