| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import External Data Source File Location Changed
Hi,
I have setup an Access database which holds tables of information I need to present in Excel. I have setup an 'Import External Data' Access Query, which works fine and pulls through fresh data when I refresh the query, however I moved the source file to another location and it can't find it. Is there a way I can change this, I have 12 worksheets linking to different tables in this database and am slightly reluctant to set them up again if I don't need to. Thanks for any help... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import data from txt file , the data prefix with plus "+" | Excel Discussion (Misc queries) | |||
| Data Source Name Not Found | Excel Worksheet Functions | |||
| Import data file but exlude information I already have in sheet? | Excel Discussion (Misc queries) | |||
| Using "Get External Data" | Excel Worksheet Functions | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Threaded Mode
