Keep Formatting - Access to Excel

[hank755_ca]

Hello,

I have a report in Access which I want to export to Excel with the
formatting intact. The formatting is rather complex with several
headings and fields with borders. I have tried the "Analyze This"
command but the formatting is totally lost.


Is there a way I can save as much of the formatting as I can? Are their

third party software that can do this?


Thanks in advance

 

[Joseph Meehan]

Hello,

I have a report in Access which I want to export to Excel with the
formatting intact. The formatting is rather complex with several
headings and fields with borders. I have tried the "Analyze This"
command but the formatting is totally lost.


Is there a way I can save as much of the formatting as I can? Are
their

third party software that can do this?


Thanks in advance

I don't think there is any way to do what you want, but I can think of a
couple of ways that you might make it easier on the other end if you use the
same format each time. Check over at the Excel NG.

 

[Craig Hornish]

See my quote

The way I would do it would take time and effort but it is possible.

There may be a third part app to do this but I usually try to do things
myself so the
way I would do it is through "Automation". .

You would directly control the process of exporting the data to the
Excel sheet, and
creating the formating.
I won't go into a complete discusion
but basically you set a reference to the Excel Object Library and then can
use that to
Open a Workbook, Set cell values and format the cells.

If you decide to go this way I can show you an example of something I am
developing.
--
Craig Hornish
chornis at cap-associate.com

Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"

 

[Smartin]

See my quote

The way I would do it would take time and effort but it is possible.

There may be a third part app to do this but I usually try to do things
myself so the
way I would do it is through "Automation". .

You would directly control the process of exporting the data to the
Excel sheet, and
creating the formating.
I won't go into a complete discusion
but basically you set a reference to the Excel Object Library and then can
use that to
Open a Workbook, Set cell values and format the cells.

If you decide to go this way I can show you an example of something I am
developing.

Hi Craig. I would be interested to learn more about what you are doing
with Access-->Excel automation.

Kind Regards,