I ran into this same problem yesterday and too was baffled. I finally
found that if I unchecked the "Save query definition" option in the
External Data Range Properties box (accessed by clicking on the
Properties button in the Import Data box you see after clicking on the
Finish button in the Import External Data wizard), I could import data
from another text file (the import data option wasn't grayed out
anymore). Hope this helps.


--
kathynewman
------------------------------------------------------------------------
kathynewman's Profile: http://www.excelforum.com/member.php...o&userid=33878
View this thread: http://www.excelforum.com/showthread...hreadid=519875