Exporting to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which I would like to export regularly to Excel so that I can e-mail it to a colleague. As often happens, the formatting gets a bit mucked up in the process. I have previously used a database which somehow exported to a template in Excel, so that the data from all the fields ended up in exactly the right places. I've looked all over but I can't seem to find the start-off point for doing this (some kind of wizard etc). Does anyone know what to do

I should point out that, although I have a certain amount of experience with simple databases, I know very little in the way of code.
 
Reports don't export well to Excel. I suppose if you new
Excel you could program its macros to clean it up.

If you want to send an attachment that looks good, export
the report as an RTF instead. This opens in MS Word and
has all the formatting except for the lines.

If you need to send him the data to work with. Create a
customized query which exports perfectly to Excel. A
query can be customized with filters, expressions and
totals.

Just a few ideas.

Kevin
-----Original Message-----
I have a report which I would like to export regularly to
Click to expand...
Excel so that I can e-mail it to a colleague. As often
happens, the formatting gets a bit mucked up in the
process. I have previously used a database which somehow
exported to a template in Excel, so that the data from all
the fields ended up in exactly the right places. I've
looked all over but I can't seem to find the start-off
point for doing this (some kind of wizard etc). Does
anyone know what to do?
I should point out that, although I have a certain amount
Click to expand...
of experience with simple databases, I know very little in
the way of code.
 
Thanks Kevin

----- Kevin wrote: ----

Reports don't export well to Excel. I suppose if you new
Excel you could program its macros to clean it up

If you want to send an attachment that looks good, export
the report as an RTF instead. This opens in MS Word and
has all the formatting except for the lines

If you need to send him the data to work with. Create a
customized query which exports perfectly to Excel. A
query can be customized with filters, expressions and
totals

Just a few ideas

Kevi
-----Original Message----
I have a report which I would like to export regularly to
Click to expand...
Excel so that I can e-mail it to a colleague. As often
happens, the formatting gets a bit mucked up in the
process. I have previously used a database which somehow
exported to a template in Excel, so that the data from all
the fields ended up in exactly the right places. I've
looked all over but I can't seem to find the start-off
point for doing this (some kind of wizard etc). Does
anyone know what to doof experience with simple databases, I know very little in
the way of code
 
Back
Top