Susan,
But bear in mind that your code would then not be compatible with previous
versions of Excel, ones with rows.count<1 million.

Nick

"Susan" wrote in message
oups.com...

NickHK wrote:
Sue,
To add to Duke's info: You can get the data into Access quite easily
with
its Import feature.

Or get Office 12, which apparently extends the rows.count to something
like
1 million.

NickHK


Nick, I didn't see a reply from Duke, but I do thank you for the heads
up on Office 12.

Susan