Share via

Copying data from an Access table into an array

Anonymous
2012-11-07T02:32:37+00:00

I know how to copy data from an Excel range into an array (and vice versa), but I don't know how to do the same thing with an Access table.

I would greatly appreciate any assistance in this area.  Thanks.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2012-11-07T07:09:19+00:00

Take a look at the GetRows method of the Recordset object: http://msdn.microsoft.com/en-us/library/office/ff194427.aspx.

So you open a recordset on the table, then use its GetRows method to populate a two-dimensional array.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-11-07T17:55:42+00:00

    That's the info I was looking for.  As always, thanks!

    Was this answer helpful?

    0 comments