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...

If Not oRS.EOF Then
ary = oRS.getrows


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Deke" <(E-Mail Removed)> wrote in message
news:A14135A7-88B6-4A2E-BC20-(E-Mail Removed)...
>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...

Thanks, I works great, but for some reason it puts into a multi-dimensional
array...
--
Cheers...


"Bob Phillips" wrote:

>
> If Not oRS.EOF Then
> ary = oRS.getrows
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Deke" <(E-Mail Removed)> wrote in message
> news:A14135A7-88B6-4A2E-BC20-(E-Mail Removed)...
> >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...
>
>
>

That is because the data is multi-dimensional, rows x columns

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Deke" <(E-Mail Removed)> wrote in message
news:5F031AE3-0002-487F-B6CD-(E-Mail Removed)...
> Thanks, I works great, but for some reason it puts into a
> multi-dimensional
> array...
> --
> Cheers...
>
>
> "Bob Phillips" wrote:
>
>>
>> If Not oRS.EOF Then
>> ary = oRS.getrows
>>
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>> "Deke" <(E-Mail Removed)> wrote in message
>> news:A14135A7-88B6-4A2E-BC20-(E-Mail Removed)...
>> >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...
>>
>>
>>

Deke wrote:
> Thanks, I works great, but for some reason it puts into a multi-dimensional
> array...

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

ary = ArrayReshape(ary, 1, ArrayCount(ary)) will convert it to a 1-D array.

Alan Beban