Excel as Interface

[Roderick_E]

Ok so I'm about to move into the wonderful world of Access DB, but I want to continue to use my Excel skills. I intend to create a workbook that will pull just certain elements from the Access DB. I don't need to download the entire DB each time do I?

 

[CalcSux78]

I prefer to use a public array to store the data temporarily using the GetRows Method