Solved

Error using Saved Imports in Access 2007

Posted on 2011-02-14
6
402 Views
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.
0
Comment
Question by:Barry Sweezey
6 Comments
 
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.

regards,

Bill
0
 
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.

Bill
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34900353
And just to be sure, get rid of the underscore as well.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Accepted Solution

by:
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".  
0
 

Author Closing Comment

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

Expert Comment

by:jimfox99
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.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

810 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