itbabe
asked on
MS Access 2007 :When running an a saved excel import we get "The specification failed to execute. Try recreating the specification." What could I try to solve this issue ?
Please advise.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rey Obrero (Capricorn1)
post at #a40972773 should resolve this issue.
An addition to Jeffrey Coachman's "Accepted Solution" above:
When running a Saved Import on an Excel file (I'm using MS Access Professional Plus 2016), not only must the number of fields, data types, etc. be the same as they were when you created the original specification, but even the spreadsheet tab name (at the bottom of the worksheet) must be the same.
I wrote up a multi-step process which included a step to import spreadsheet data differing only on a date range. I used the same file name (e.g., FileName_WorkingDates) and columns every time I created the spreadsheet, but I would modify the tab name as a reference to go back to if I needed to check what date range I was working on. Every time I ran the import, I would get the error in this post's title. However, that message was actually preceded by another error message:
"<original tab name>$" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
It took me some while to figure out that the <original tab name> text in this error message was what I had entered in the tab in the file used when I created and saved the import. Based on Jeffrey's post, I decided to change the file's tab name to <original tab name>, and voila, the import worked.
Thanks for this post.
When running a Saved Import on an Excel file (I'm using MS Access Professional Plus 2016), not only must the number of fields, data types, etc. be the same as they were when you created the original specification, but even the spreadsheet tab name (at the bottom of the worksheet) must be the same.
I wrote up a multi-step process which included a step to import spreadsheet data differing only on a date range. I used the same file name (e.g., FileName_WorkingDates) and columns every time I created the spreadsheet, but I would modify the tab name as a reference to go back to if I needed to check what date range I was working on. Every time I ran the import, I would get the error in this post's title. However, that message was actually preceded by another error message:
"<original tab name>$" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
It took me some while to figure out that the <original tab name> text in this error message was what I had entered in the tab in the file used when I created and saved the import. Based on Jeffrey's post, I decided to change the file's tab name to <original tab name>, and voila, the import worked.
Thanks for this post.