formatted excel into access report

[bev a via AccessMonster.com]

For reasons unknown at this time, my supervisor wants to see the output from
a very detailed and highly formatted (style and color) Excel spreadsheet as
an Access report. I have no trouble using TransferSpreadsheet to get the
data from Excel into Access in table form, but does anyone know if there is a
way to automatically transfer all the formatting without reprogramming it to
go directly to a report format.. I can't seem to find any way to do it.
thanks in advance
Bev A

 

[Guest]

Nope. You are going to have to set the formatting up by hand.
Well, you could do some extenisve VBA that would read the formatting of the
spreadsheet, and modify the report's properties, but that would be a one time
pass to create the report object.

This is not a reasonable thing to do. I suggest you quit your job and go
join the circus.

 

[bev a via AccessMonster.com]

thank you for your opinion.........I kind of figured that was the case.......
but I think I'll keep the job - I actually enjoy it...........

Nope. You are going to have to set the formatting up by hand.
Well, you could do some extenisve VBA that would read the formatting of the
spreadsheet, and modify the report's properties, but that would be a one time
pass to create the report object.

This is not a reasonable thing to do. I suggest you quit your job and go
join the circus.

For reasons unknown at this time, my supervisor wants to see the output from
a very detailed and highly formatted (style and color) Excel spreadsheet as

[quoted text clipped - 4 lines]

thanks in advance
Bev A