The table doesn't have to be open in order for you to invoke "Get External Data" menu item. What needs to be open is the database window so if your table is indeed open close it and try the operation again. If it fails again then we can start troubleshooting from there.
Regards Liveson ----- Original Message ----- From: cathybinva To: [email protected] Sent: Friday, 14 November, 2008 21:32 PM Subject: [ms_access] getting started importing data Access 2003 - I am following the instructions in the Help function to import data to an existing table from an Excel spreadsheet. Everything goes great until I say "Finish". then I get a message that the table I want to import the data to is "already open" and it won't let me go any farther. Of course the table is open - it has to be open in order for me to invoke the Get External data function under the File tab. What am I doing wrong. I used to create Access applications many years ago but now everything is new and I'm having to learn a lot of stuff all over again. Thanks!!! [Non-text portions of this message have been removed]
