Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / February 2008

Tip: Looking for answers? Try searching our database.

Excel to Access Form ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pat Coleman - 26 Feb 2008 20:38 GMT
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@hotmail.com - 27 Feb 2008 02:21 GMT
> A Little off Topic  -
>
[quoted text clipped - 11 lines]
>
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.