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

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
Karen SchaeferBI ANALYSTAsked:
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.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
Karen SchaeferBI ANALYSTAuthor Commented:
yep I am able to view the data in the tables,  however, where do I make modifications?

K
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Karen SchaeferBI ANALYSTAuthor Commented:
How do I view the exiting specs in Access 2007 when I am unable to view them using the wizard?

K
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Don't know if we crossed posts ... did you see the post just above with image ?
0
Karen SchaeferBI ANALYSTAuthor Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
Karen SchaeferBI ANALYSTAuthor Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Ah so ... let me look at A2010 ... no have A2007.
0
Jeffrey CoachmanMIS LiasonCommented:
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

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
Karen SchaeferBI ANALYSTAuthor Commented:
thanks for your input.

Karen
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Sorry, I ended up a meeting until 19:00 !!

mx
0
Jeffrey CoachmanMIS LiasonCommented:
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
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.