bringing data into excel from access

[Lino]

hello,


In excel there are named ranges how do you pull data from a specific column and row using excel vba communicating with the access database? Do you call a range in access?

thanks,

lino

 

[mdmilner]

From Access, pushing down into Excel, try this link:
That's actually three slightly different techniques.

http://www.mvps.org/access/modules/mdl0035.htm

What it doesn't do is include how to identify the specific Column (Fields) and Row (Records) you wish to send to Excel.

Easiest method for you, probably, is to open up a filtered recordset object and use sCopyFromRS subroutine.

Mike