Excel to Access Form ?

[Pat Coleman]

A Little off Topic -

Is it possible to create a report in access from an excel template.

A Vendor has given us an excel template that we need to reproduce for each
of our inventory items. I have no way of figuring out how to design it as an
Access Report. The form they gave us was in Excel format.

Is there a way to save the excel page as a MS report and then fill in the
fields with date from our access data base.

Pat
Is there a way to save it as a access form.

Any pointers would be appreciated.

 

[pietlinden]

A Little off Topic  -

Is it possible to create a report in access from an excel template.

A Vendor has given us an excel template  that we need to reproduce for each
of our inventory items. I have no way of figuring out how to design it as an
Access Report. The form they gave us was in Excel format.

Is there a way to save the excel page as a MS report and then fill in the
fields with date from our access data base.

Pat
Is there a way to save it as a access form.

Any pointers would be appreciated.

why not use ADO to pass the recordset to Excel and then manipulate it
there in the template? you should be able to specify the range to
copy the data to. I am pretty sure there are examples of it on Access
Web. www.mvps.org/access