A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Exporting Query from Access 2007 to Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 08:46 PM posted to microsoft.public.access
amw0830
external usenet poster
 
Posts: 7
Default 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  
Old April 30th, 2010, 11:50 PM posted to microsoft.public.access
rashawn raymond
external usenet poster
 
Posts: 1
Default 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  
Old May 1st, 2010, 06:16 AM posted to microsoft.public.access
vbasean
external usenet poster
 
Posts: 113
Default 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  
Old May 1st, 2010, 06:20 AM posted to microsoft.public.access
Murphy, Jonathan
external usenet poster
 
Posts: 3
Default 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  
Old May 7th, 2010, 05:02 PM posted to microsoft.public.access
Ken Snell
external usenet poster
 
Posts: 177
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.