I had an access table with 105,000 records and 33 columns (3 numeric). From Excel (2002) I made an ODBC link to this table in Access (2002) using microsoft query and it worked fine.
I then added a numeric column and about 5,000 records and suddenly I can no longer extract the data into Excel...