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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill RossProgrammerCommented:
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 RossProgrammerCommented:
Hi again,

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

Bill
0
Jeffrey CoachmanMIS LiasonCommented:
And just to be sure, get rid of the underscore as well.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Barry SweezeySoftware 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.