Hi all,
I'm trying to import some tables from one Access 2007 database into a new blank Access 2007 database. There are 7 tables in my old database. I want to import all of them. I go to the "external data ribbon" and choose "access" as the source and then get the dialog box to choose what to export and where from, I click the OK button to export but one table is not exporting. All the other tables are. The table that is not exporting is my main table where all my data is stored. Instead, I get an object under tables in the new blank database named "Name AutoCorrect Save Failures". I open this table object and under "failure reason" it says "Could not open the object".
Does anyone know a solution to this or what I may be doing wrong? Is it perhaps due to a corrupted database? When I open the old database and try to enter data everything works fine. The only thing I can't seem to do is import the one table.
Thanks for any help!
Gary