Error using Saved Imports in Access 2007
Posted on 2011-02-14
I've created saved imports that fail when I try to use them. I've created them and used them right away and they worked. They fail when I try again. I have three versions of one saved. Here are the errors from each:
1. "Z0ANALYSIS_PATTERN 3 $" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
2. "Import$" is not a valid...
3. The one I just created works.
It seems like the Saved Import works for the file I used to create it, but fails with the next one.
The Excel file was created by SAP BI; the query result was exported to Excel. The name of the worksheet is Z0ANALYSIS_PATTERN 4. I tried changing the name of the worksheet to "Import"; I think that's why error #2 contains the string "Import$". I suppose the invalid character the error is referring to is "$", but that's not in the worksheet name.