Exporting to a Word or Excel Template

Jkittle

Registered User.
Local time
Today, 15:55
Joined
Sep 25, 2007
Messages
100
I have to complete a form for my customer that is currently in Excel. The form is very cumbersome to use plus I have to maintain records and trends on the data. I have to use there layout. Is there a way that I can use Access as the data entry and export the information into a Word or Excel Template?

I did create an Access report that looks exactly like the Excel form, however you can only print it. If I try sending it electronically (customer requirement for editing) I lose all the borders and have to send it a rich text format. Unfortunately this is unacceptable to my customer.
 
Hi J
What about exporting the "raw" data to a "neutral" workbook and then point the original workbook to source the data from the "neutral"?
 

Users who are viewing this thread

Back
Top Bottom