?
Solved

MS Access 2007 - Edit Saved Import Settings - EXCEL SOURCE

Posted on 2009-05-01
8
Medium Priority
?
1,508 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:ADMISARL
  • 4
  • 4
8 Comments
 
LVL 39

Expert Comment

by:thenelson
ID: 24284469
You could link to the Excel file and always have the most current Version without needing to import.
0
 

Author Comment

by:ADMISARL
ID: 24294187
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
 
LVL 39

Expert Comment

by:thenelson
ID: 24296930
>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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ADMISARL
ID: 24303270
i just saved them using the "import wizard".  Are these possible to be viewed in code form?  
0
 
LVL 39

Assisted Solution

by:thenelson
thenelson earned 600 total points
ID: 24304295
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
 

Accepted Solution

by:
ADMISARL earned 0 total points
ID: 24305162
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
 

Author Comment

by:ADMISARL
ID: 24305531
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
 
LVL 39

Expert Comment

by:thenelson
ID: 24305825
Glad you found a solution.

Nelson
www.thenelson.name
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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 …

850 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