Combine Access & Excel

[Ralph Bender, MBA]

Office XP
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.

Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it might be
practical to run them somehow into one of the other platforms.

Thanks,
Ralph

 

[punjab_tom]

open a report, go Insert, Autoform.. and then you got the option to
insert an office web component, spreadsheet

put your Excel crap in there

hope that helps

-Tom
DBA

 

[punjab_tom]

Insert ActiveX I meant not autoform

 

[Guest]

Hi Ralph,

A couple of possibilities for you;
1. Link the spreadsheet results to the Access database and incorporate them
as a subreport on your template,
2. Get Access to do the calculation that Excel is doing and do the whole
task within the application,
3. Export the Access report to Word, then link Word to the Excel sheet.

My advice would be to link the spreadsheet into Access as a linked table.
That way the data remains dynamic.

Hope this points you in the right direction.

Regards,

Nick. (A fellow MBA)

 

[Ralph Bender, MBA]

Actually, a simple cut and paste from Excel into the Access template works
as a temporary fix. I just need to suppress the gridlines in Excel and the
borders in Access before printing.

Thanks for your insights.

I take it you're not a fan of Excel ...

 

[Ralph Bender, MBA]

Thanks Nick!

I think for the time being, I'll do simple cut n paste of my Excel layouts
into the Access reports, then develop the actual programming to accomplish
the same thing within Access. It'd produce a more uniform result in the
future.

I really appreciate your insights. Without asking the questions, I wouldn't
have realized how easy it is to just cut n paste!

Ralplh