I am currently using the CopyfromRecordset function to copy data from an
Access database into Excel worksheets.

The only problem is that I now have a requirement to read the data directly
into an array rather than to a worksheet.

I thought I read something on the forum about this a couple of weeks ago,
but I cannot find it again, any help would be greatly appreciated.

--
Cheers...