Solved

Editing Existing Import Specs in 2007 for an imported Import spec from Access 2003 mdb

Posted on 2012-03-14
13
329 Views
Last Modified: 2012-03-15
How do I access an imported "Import Spec" from an Access 2003 database in Access 2007.  When I click on Saved Imports - there are none displayed in the wizard, however, my code runs successfully when I use/call an import specification.

I need to modify 1 spec to change table fields sizes and names.  Where do I access this info in the specs?

Thanks,

Karen
0
Comment
Question by:Karen Schaefer
  • 6
  • 5
  • 2
13 Comments
 
LVL 75
ID: 37722502
Well, first ... confirm that you really have existing specs ... 1) confirm these two tables are present and 2) open and see what you recognise:

1
mx
0
 
LVL 75
ID: 37722580
Here is one way to get to it:
File>>Get External Date >> Import.
Pick any TXT or CSV file, and bring up the Import Dialog ... then click on Advanced - image

1
0
 

Author Comment

by:Karen Schaefer
ID: 37722583
yep I am able to view the data in the tables,  however, where do I make modifications?

K
0
 

Author Comment

by:Karen Schaefer
ID: 37722591
How do I view the exiting specs in Access 2007 when I am unable to view them using the wizard?

K
0
 
LVL 75
ID: 37722599
Don't know if we crossed posts ... did you see the post just above with image ?
0
 

Author Comment

by:Karen Schaefer
ID: 37722608
Yes I saw you post - however I do not want to create a new spec I want to be able to view my existing specs, and modify if necessary?import spec
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 75
ID: 37722624
Well, referring to my image, if you click on Specs, it should show existing specs (I have one) ... then you open that ... wherein you can modify it.  

Is that not happening for you?

mx
0
 

Author Comment

by:Karen Schaefer
ID: 37722635
Joe, you are using 2003 - I am using 2007 - that is where the problem lies - I know how to do it in 03 - but 2007 handles things differently.

any Ideas?

Karen
0
 
LVL 75
ID: 37722648
Ah so ... let me look at A2010 ... no have A2007.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37723058
Just some clarification, ...a Saved Import is not the same thing as an Import Specification.

Saved Imports are created when you click the "Save Import Steps" button at the end of the import/export wizards.
They are accessible via External Data tab, under Import, and under Export.
And they *cannot* be edited.

An import Specification is created by clicking the Advanced button *during* the import/export wizard.
I believe that MX has given you all the info on this...
 

So lets be clear, ...are you wanting to modify a Saved Import or an Import Specification?
You seem to be using both terms interchangeably in your question body:
<How do I access an imported "Import Spec" from an Access 2003 database in Access 2007.  When I click on Saved Imports

Again, if you in fact clicked "Saved imports", you are accessing just that, ...a  "saved Import", ...not an Import Specification.

JeffCoachman
0
 

Author Closing Comment

by:Karen Schaefer
ID: 37725291
thanks for your input.

Karen
0
 
LVL 75
ID: 37725361
Sorry, I ended up a meeting until 19:00 !!

mx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37725519
Just so we are clear,

I never used this new "Saved Import" option, I only use Import Specs...

So unless you have a specific reason for selecting "Save Import Steps", I would just go with Import Specs.
At least as MX pointed out, Import Specs can at least be edited to a certain extent.
They can also be use in VBA.

I think Saved imports were an attempt to make it easy for a basic end user to import the same file over and over again...
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

896 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now