Import Excel file as report template - possible?

[justinwright]

The subject pretty much sums it up.



Is it possible to import an excel file into Access as a report?

I have an Excel file that looks like how I want the data presented, with the data filled in on the Excel sheet.

If it's not possible, I take it I would have to export to the Excel file and print the Excel file? Does anyone have a few informational links handy on that, in that case?

Thanks in advance for the help!

[ajetrumpet]

as far as I know, the report template feature in Access can only apply to actual report objects that are created and styled in Access itself.

[justinwright]

So I assume that means I'd need to export data to Excel?

Would you happen to have any links handy for info on that (preferably something that just opened the file, exported the selected data to the excel sheet, printed the current sheet in the workbook, and closed the file without saving changes without any prompts or anything)?

EDIT:

I found some links for Exporting from Access to Excel, like here for anyone that needs:
http://www.databasedev.co.uk/exporti...-with-vba.html
http://www.vbforums.com/showthread.php?t=376693

For Printing:
http://forums.devx.com/archive/index.php/t-78786.html

This is close to the cumulative problem:
http://bytes.com/topic/access/answer...eport-printing

I figured I'd post these for anyone else wondering, I'll mark this solved.

Thanks for the help!