Solved

Error using Saved Imports in Access 2007

Posted on 2011-02-14
6
406 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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