Dear all,
I have designed a macro in Access 2007 that imports excel data from a files. Name of excel file are Form A, Form B, and Form C. I recently installed Access 2010. Now when I click the import button, the macro pops up a message saying that "Form A" doesn't exist in the location - this is true. But Form B and C are there. I want the macro to import data from those files only that exist in a specified fold.
In Access 2007, database would import existing data only. It didn't give me a message if Form A or any other form wouldn't exist in the specified location.
What can I do to make the macro behave similar to what it was doing in previous version?
Appreciate your help.
Regards,
Dad
I have designed a macro in Access 2007 that imports excel data from a files. Name of excel file are Form A, Form B, and Form C. I recently installed Access 2010. Now when I click the import button, the macro pops up a message saying that "Form A" doesn't exist in the location - this is true. But Form B and C are there. I want the macro to import data from those files only that exist in a specified fold.
In Access 2007, database would import existing data only. It didn't give me a message if Form A or any other form wouldn't exist in the specified location.
What can I do to make the macro behave similar to what it was doing in previous version?
Appreciate your help.
Regards,
Dad
