Hi,

Apologises if there is a thread relating to this else where, just could find
it.

I am having problems when I import data into Excel 2000 from Access 2000 and
hope someone can help.
The data appears in my workbook but I am unable to use any lookup on this
unless I F2 and enter on each cell. As the table I'm importing contains
20,000+ rows this is taking some time to complete.
I have tried copying and pasting, using the new DB query wizard in the Data
menu, and formatting the both sets of data to General, Text, etc but nothing
seems to work!
Any suggestions would be greatly received,
Jon