Prev: Numbering
Next: Querying data - Graph Report
From: AMW0830 on 30 Apr 2010 15:46
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.
From: rashawn raymond on 30 Apr 2010 18:50
sup news group i need mails



"AMW0830" <AMW0830(a)discussions.microsoft.com> wrote in message
news:D80A3288-8DAB-45D0-AD37-FCEE3CB4D142(a)microsoft.com...
>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.

From: vbasean on 1 May 2010 01:16
Have you tried connecting the worksheet directly to the data?

http://office.microsoft.com/en-us/excel/HA101672271033.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.
From: Murphy, Jonathan on 1 May 2010 01:20
This website helped me.

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

"vbasean" <vbasean(a)discussions.microsoft.com> wrote in message
news:1342E342-DDAD-405D-B9BD-67EA25E4EE44(a)microsoft.com...
> Have you tried connecting the worksheet directly to the data?
>
> http://office.microsoft.com/en-us/excel/HA101672271033.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.

From: Ken Snell on 7 May 2010 12:02
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


--

Ken Snell
http://www.accessmvp.com/KDSnell/


"AMW0830" <AMW0830(a)discussions.microsoft.com> wrote in message
news:D80A3288-8DAB-45D0-AD37-FCEE3CB4D142(a)microsoft.com...
>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.


 | 
Pages: 1
Prev: Numbering
Next: Querying data - Graph Report