heyyyyy !! im working as an internee in a company ..and im given a
database.. which is made in access 97... the problem is ..that when we click on the X sign for excel in reports ........
the reports dont open in excel in the proper format , the boss doesnt want an indirect way by saving the reports as html and then
opening in excel ...
access 2002 dont have this problem i guess... i was wondering if converting
acess97 db to access 2002 would corrupt the database or not.
another solution cud be .. using the pivot tables .to view reports in excel ... which i dont know
how to use..
Also ... the reports do open in Word in rich text format ... but the table (lines) dont appear ... im thinking of doing that with macros.... any easy way out??


please any body have any solution .. do tell me
.. its urgent... else my internship wud be extended ..lol

You can use the Output To Action in a macro to convert the report output to either Excel or Word and choose which version of Excel to export the output to.

As you are finding this won't keep the layout as it appears in Access. Only snapshot format will keep the exact same layout as access. There are other methods such as taking the output to PDF Format or if you still want to keep it in word I have posted a sample here in another thread that will show you how to do this by using VBA. A macro will not work if you want to keep the same layout as access unless you use snapshot.

Hay