export to preformatted Excel document with formulas in first row

  • Thread starter Thread starter Jvandela
  • Start date Start date
J

Jvandela

Access Export to Preformated Excel Document
From: "Daryl Hageman"
<[email protected]> Sent: 6/2/2004
8:17:42 AM


I have a similar issue as Daryl above...
I have created an Access db and would like to export it to
a preformatted Excel spreadsheet that has lines of text,
image, and formulas in the first 7 rows. I would like to
specify where data goes into Excel.

Can this be done? It is also a linked spreadsheet from
Access to Excel.

Thank you.
jana
 
Hi Jana,

This sounds like a mess: exporting data from Access to a worksheet that
is also the data source of a linked table and a display-formatted sheet
to be seen by the user. Can't you just use an append or update query to
write the data to the linked table? (define a named range on the sheet
to include only the table area and exclude the top rows apart from the
column headers).

Otherwise, one or other of the solutions in this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;247412 should
let you do what you want.
 
Hi -

I am just an occasional user of Access. I will try your
suggestion.

Thank you.
-----Original Message-----
Hi Jana,

This sounds like a mess: exporting data from Access to a worksheet that
is also the data source of a linked table and a display- formatted sheet
to be seen by the user. Can't you just use an append or update query to
write the data to the linked table? (define a named range on the sheet
to include only the table area and exclude the top rows apart from the
column headers).

Otherwise, one or other of the solutions in this article
http://support.microsoft.com/default.aspx?scid=kb;en- us;247412 should
let you do what you want.



Access Export to Preformated Excel Document
From: "Daryl Hageman"
<[email protected]> Sent: 6/2/2004
8:17:42 AM


I have a similar issue as Daryl above...
I have created an Access db and would like to export it to
a preformatted Excel spreadsheet that has lines of text,
image, and formulas in the first 7 rows. I would like to
specify where data goes into Excel.

Can this be done? It is also a linked spreadsheet from
Access to Excel.

Thank you.
jana
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top