Importing Query results to Excel

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am running a query and would like the results to
populate certain cells in an excel spreadsheet. Is there
a way to have a field in my query be sent to a specific
column in Excel?

Thanks,

Chuck
 
Chuck,

You may want to try designing your query in Access, then
in Excel, look at using Data/Import External Data under
the main menu. That's one way you can populate
spreadsheets.

Mark
 
Programmatically, you could create a recordset with just
that one field and use the CopyFromRecordset method?
 
Back
Top