Export Data from Access to Excel spreadsheet Location

Tim · Dec 16, 2003

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 · Dec 16, 2003

Tim said:
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