can anyone tell me how to open an excel spreadsheet from access 2003. I used to be able to do this in access 97 but I can't find a way to open or link a spreadsheet
Go to File - Get External Data. Chose to either link or import. When the file dialog box appears, change the dropdown from Microsoft Access to Microsoft Excel and select your file.
