If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exporting Query from Access 2007 to Excel 2007
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. |
#2
|
|||
|
|||
Exporting Query from Access 2007 to Excel 2007
sup news group i need mails
"AMW0830" wrote in message news 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. |
#3
|
|||
|
|||
Exporting Query from Access 2007 to Excel 2007
Have you tried connecting the worksheet directly to the data?
http://office.microsoft.com/en-us/ex...672271033.aspx -- ~Your Friend Chris "AMW0830" wrote: 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. |
#4
|
|||
|
|||
Exporting Query from Access 2007 to Excel 2007
This website helped me.
http://office.microsoft.com/en-us/ex...672271033.aspx "vbasean" wrote in message ... Have you tried connecting the worksheet directly to the data? http://office.microsoft.com/en-us/ex...672271033.aspx -- ~Your Friend Chris "AMW0830" wrote: 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. |
#5
|
|||
|
|||
Exporting Query from Access 2007 to Excel 2007
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/EXC...t.htm#ExpRange -- Ken Snell http://www.accessmvp.com/KDSnell/ "AMW0830" wrote in message news 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. |
Thread Tools | |
Display Modes | |
|
|