Tried that, but this database that I'm trying to import is not in my
local or share drives. It is in some network that I have limited access
to. Are there any other ways to tackle this problem?

And any idea why selecting text from the field (rather than from inside
each cell) should have a character limit in it? Is there anywhere (in
Access or in Excel) that I can change this limit?

Thanks,

Joe.