2007 Import Error

[OEJ29]

Users that have been upgraded from Office 2003 to Office 2007 are having
trouble importing into Access 2003 databases.

They are getting an error message that the file path is not valid. However,
in that file path the import wizard specifies in the error message, it is
hard coding a database on another file share and not the database that is
open and they are attempting to import into.

Any ideas on what may be causing this and how to fix it would be greatly
appreciated.

 

[OEJ29]

Found the resolution to this problem.

One of the linked tables in the database was being stored in a folder that
had an apostrophe in the name. This is an invalide character.

By renaming the folder and using the Linked Table Manager to update the new
folder, I have been in business.

Even though you aren't importing into that particular table, Access 2007
checks all the integrity within the database.