I know I am suppose to be able to import an Excel spreadsheet into Access. I follow the directions given by Microsoft help
1. Open a database, or switch to the Database window for the open database.
2. To import a spreadsheet, on the File menu, point to Get External Data, and then click Import.
3. In the Import (or Link) dialog box, in the Files Of Type box, select Microsoft Excel or Lotus 1-2-3.
This is where I have to stop. I do not get the option of Microsoft Excel. I only get:Microsoft Access, Text Files, HTML documents and ODCB Databases.
I have installed all features from the Office 97 CD and even the Value Pack Dataacc.exe program, but nothing.
1. Open a database, or switch to the Database window for the open database.
2. To import a spreadsheet, on the File menu, point to Get External Data, and then click Import.
3. In the Import (or Link) dialog box, in the Files Of Type box, select Microsoft Excel or Lotus 1-2-3.
This is where I have to stop. I do not get the option of Microsoft Excel. I only get:Microsoft Access, Text Files, HTML documents and ODCB Databases.
I have installed all features from the Office 97 CD and even the Value Pack Dataacc.exe program, but nothing.