ADMISARL
asked on
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
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
You could link to the Excel file and always have the most current Version without needing to import.
ASKER
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?
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?
>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.
How did you save your import settings? Macros and code cam easily be changed.
ASKER
i just saved them using the "import wizard". Are these possible to be viewed in code form?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Thanks for sticking on it thenelson