i run office 2000 on an xp operating sytem...whenever i try to import data from an external source, excel locks up. has anyone encountered this before? if so, is there a known fix? thanks for the help....
When using Microsft query, with the size of recordsets i look at it can take an absoloute age to come through, sometimes as much as 1/2 an hour,
if i have to do something like this i usually try to let it run on a seperate machine
if you give it enough time it will probably come through
how long have you let it run before, what size of file are you trying to import, what kind of system are you importing from - i usually run to a SQL server which takes longer than running from Access
Have you tried connecting through an ADO recordset then writing this recordset to a worksheet, although this is slow it may help pinpoint the problem whether its network or down to your local instance of MS Query