Error using Saved Imports in Access 2007

Posted on 2011-02-14
Medium Priority
Last Modified: 2014-05-21
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.
Question by:Barry Sweezey
LVL 14

Expert Comment

by:Bill Ross
ID: 34893202
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.


LVL 14

Expert Comment

by:Bill Ross
ID: 34893215
Hi again,

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

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34900353
And just to be sure, get rid of the underscore as well.
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.


Accepted Solution

Barry Sweezey earned 0 total points
ID: 34918404
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".  

Author Closing Comment

by:Barry Sweezey
ID: 34949733
I regard this as a work around.

Expert Comment

ID: 40081059
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.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question