Whenever I use the "Import External Data" function on the "Data" menu, a
window pops up with a default directory/folder called "My Data Sources".

Is there a way to change this default to another directory?

Thanks.

From the Control Panel (and possibly from there to Administrive Tools)
doubleclick Data Sources (ODBC)
On the File DSN tab, you can click Set Default Directory

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Martin" wrote in message
...
Whenever I use the "Import External Data" function on the "Data" menu, a
window pops up with a default directory/folder called "My Data Sources".

Is there a way to change this default to another directory?

Thanks.