Import report format from excel?

[ckiley]

I work for a state, and governments do love their forms. We have payment data in Access 2003, and the state requires us to make a payment request using a specific form that they created in excel format. We'd like to re-create the official form in Access, so our admin person won't have to fill out the excel form by hand. Is there a way to import the excel format to an Access report, so we can then set the control source to the right field in our database? Would it be better to tackle this from the excel side using a mail merge? I'm trying to avoid having to format a report in Access to exactly match an excel file.
Thanks ahead for any tips!

 

[HiTechCoach]

If may be possible to place the excel file in the form as the "back ground" and place text box controls over it. I have do this with Word and PDF files.

 

[ckiley]

Yep! That works. Thanks for saving me all that trouble trying to get margins and fonts the same!

 

[HiTechCoach]

You're welcome.

Glad that worked for you .... Good luck with your project.