Newbie .. Arrays in excel

[Gary]

Please can anyone help, I am trying to fetch a table from an excel sheet
and make it an array in a macro, Q1 Can I, if the answer is yes Q2 How
and a little sample please

 

[GVaught]

You can link the Excel spreadsheet into Access and then use the data that is
in the linked Excel spreadsheet to create queries, forms, reports etc. This
might be easier and serve your purpose rather trying to making the data an
array in a macro.

See File | Get External Data | Link. Don't use import as this info won't get
updated as you make changes to the Excel spreadsheet or to the linked
spreadsheet within Access.