MS Access 2007 - Edit Saved Import Settings - EXCEL SOURCE

I am using MS Access 2007 to import data from an Excel file. I have saved my import settings to make it easier to duplicate the import every-time.
Is there a way to just edit the saved import rather than reccreate it?  I have done it with text files but i havent seen how to do it with excel files.

Any advice would be much appreciated.

Cheers
KD
ADMISARLAsked:
Who is Participating?
 
ADMISARLAuthor Commented:
Unfortunately you can only run or rename a saved import from what I can see.  I could redefine the imports again but not only would it take ages, if I miss defining one column correctly it will either give me import errors or break down queries further on.

Good call on the system tables, I have found MSysIMEXColumns that appears to hold the attributes for the columns but I havent seen anything that defines network path.   It has got to be hiding in there somewhere!
0
 
thenelsonCommented:
You could link to the Excel file and always have the most current Version without needing to import.
0
 
ADMISARLAuthor Commented:
Unfortunately linking wont do the trick as certain fields have to be forced to text etc.  
Also I already have everything set up and working but now i need to give multiple users access however i only saved the mapped drive path on the orignal import.  All i need to do is change the source file paths to the full network path.  Hopefully this is possible withough going through the whole process of reimporting everything.  Any ideas?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
thenelsonCommented:
>I have saved my import settings to make it easier to duplicate the import every-time.

How did you save your import settings? Macros and code cam easily be changed.
0
 
ADMISARLAuthor Commented:
i just saved them using the "import wizard".  Are these possible to be viewed in code form?  
0
 
thenelsonCommented:
I don't have Access 2007 so I am not familiar with save import parameters. How do you redo a saved import? It would either be saved in a system (hidden) table as macros are saved or in code. You can turn on hidden and system tables in options, view. Isn't this a moot point as it only takes a few minutes to create a new input?
0
 
ADMISARLAuthor Commented:
Going back over the saved import wizard (again) I finally found that you can simply double click on the path text and alter it that way.  So simple but not intuitive at all by looking at the wizard screen!
Thanks for sticking on it thenelson
0
 
thenelsonCommented:
Glad you found a solution.

Nelson
www.thenelson.name
0
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.

All Courses

From novice to tech pro — start learning today.