Hi q,

AFAIK, it's not possible to do what you're looking to do. However, I have a
few questions for you:

1) Do you really need all of the rows from your Access table? If not, do
you just need a particular subset of the data, or do you simply need totals,
counts, etc?

2) If yes to #1, why are you bringing the data into Excel? Could you
accomplish the same goals using Access?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


q wrote:
Hello. VBA in Excel XP with Win 2k.

You can insert a spreadsheet into Word and you can insert a Word
document into Excel.

Can you insert an Access Table object into Excel? I'm trying to work
around the 65,536 row limit in XL.

WHAT ARE MY OPTIONS?
Is the best thing to automate Access from XL ????????????????????

Please everyone advise. I need some guidance here. Thanks in advance
for all responses/thoughts.