Can I open an Excel spreadsheet on a form in access?

[voidcranium]

I have a form that users use to input data for our Work Orders.
They also use an excel spreadsheet to do quotes.
I would like to be able to open the quote from the Work Order form in Access so I don't have to keep opening excel just to print off the quote.

Can this be done?

Thanks

 

[voidcranium]

Maybe replicate the spreadsheet as a Datasheet in Access?

How would I go about this?

 

[CEH]

You can actually link to an Excel spreadsheet from Access. This would more or less make you Excel spreadsheet your "Backend" using the spreadsheet as a table. You do not need the DB split to do this. Your remaining tables can reside within the DB. The only problem here is the Excel sheet might be changed.
I would incorporate the quote sheet into your DB. Then all info would remain in one place, tied to the corresponding records.

 

[voidcranium]

You can actually link to an Excel spreadsheet from Access. This would more or less make you Excel spreadsheet your "Backend" using the spreadsheet as a table. You do not need the DB split to do this. Your remaining tables can reside within the DB. The only problem here is the Excel sheet might be changed.
I would incorporate the quote sheet into your DB. Then all info would remain in one place, tied to the corresponding records.

Thats my ultimate goal, but until I get it done that way I was wondering if there was a way to make it work temporarily.