Exporting Query from Access 2007 to Excel 2007

[AMW0830]

I am trying to export an Access 2007 query into a pre-existing Excel 2007
workbook. I would like the query to overwrite the 1st page in the workbook,
but it keeps creating a new page. I am exporting the data from query without
the formatting.

Any suggestions?

Thanks.

 

[rashawn raymond]

sup news group i need mails

 

[vbasean]

Have you tried connecting the worksheet directly to the data?

http://office.microsoft.com/en-us/excel/HA101672271033.aspx

 

[Murphy, Jonathan]

This website helped me.

http://office.microsoft.com/en-us/excel/HA101672271033.aspx

 

[Ken Snell]

See this article -- it may give you some insights on what is happening and
what you need to do to make it work the way you want:

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange