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.