| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Importing External Data - Can we specify the full path
Can you use a URL instead \\server\share\file?
"jay" wrote: Hi I have an excel workbook stored in a shared network drive. One of the sheets in the workbook has an external link from a csv text file (say importfile.csv) stored in a different directory in the server. Everything works fine when I open the workbook and click the refresh data icon. However, one of our team members has this shared network drive mapped to a different drive on his machine. (It is G:\sharefolder for everyone else but S:\sharefolder for this person). When this person tries to refresh the data, excel gives an error saying it cannot find G:\Sharefolder\importfile.csv to import data from. In the past, when I have used excel files, I can change the file-path in 'Edit Query' option under Data menu, Import External Data option. However, since this is a .csv file, Instead of 'Edit Query', I see the option changed to 'Edit Text Import', and therfore, I am not able to specify the full network path for the .csv file. Any suggestions to make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get external data using UNC path | Excel Discussion (Misc queries) | |||
| Importing External Data | Excel Discussion (Misc queries) | |||
| Importing External Data | Excel Discussion (Misc queries) | |||
| Get external data path | Excel Discussion (Misc queries) | |||
| How to import a path/filename when importing data into an XML list | Excel Worksheet Functions | |||
Threaded Mode
