Export Data from Access to Excel spreadsheet Location

[Tim]

I was wondering if anyone knows how to Export Data from an
access query to a specific excel spreadsheet location?
(i.e. D1)

Thanks,

Tim

 

[Arvin Meyer]

I was wondering if anyone knows how to Export Data from an
access query to a specific excel spreadsheet location?
(i.e. D1)

You can use TransferSpreadsheet or OutputTo

Both Methods will allow you provide a path for the Excel spreadsheet.

You can also use automation (OLE) to put data in specific cells:

http://www.mvps.org/access/modules/mdl0006.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access