Error using Saved Imports in Access 2007

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.
Barry SweezeySoftware EngineerAsked:
Who is Participating?
 
Barry SweezeyConnect With a Mentor Software EngineerAuthor Commented:
Instead of replacing the old file with a new one, I created an Excel file from scratch and paste the data into it every day.  I created a Saved Import using that file, and that import works every day.  The dollar signs were not in anything that was visible to me. When the import complained about "Import$", the name of the worksheet was "Import".  
0
 
Bill RossCommented:
Hi Barry,

The first time a saved import is created irt runs from the script.  Subsequent runs are pulled from the saved script so if the script does not save correctly then there are problmes.  I would suggest removing the $ and any other non standard characters from your naming.  Make sure your tables and file names are scrubbed of special characters as well.

That should make it work.

regards,

Bill
0
 
Bill RossCommented:
Hi again,

As a follow up - remove spaces as well from both table/field names and file names.

Bill
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Jeffrey CoachmanMIS LiasonCommented:
And just to be sure, get rid of the underscore as well.
0
 
Barry SweezeySoftware EngineerAuthor Commented:
I regard this as a work around.
0
 
jimfox99Commented:
I agree.  It would be nice if either Microsoft fixed the bug or somebody found a reliable "automated work-around", i.e., no "paste every day" step.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.