I need data exported from an Access database into an Excel file. The data comes from several tables, all with clearly defined relationships (the query for pulling the data aready exists), but needs to be imported into the Excel sheets into specific cells to maintain formatting (Excel sheet has a particualr arrangement of cells and formatting that must stay the same). Also, the import is not to a single Excel worksheet, but to separate sheets for particular record sets (again, the record sets and key fields are already clearly defined). Secondly, would like to be able to "reverse" the process and import data from the excel fields once they have been distributed to users, edited, and recollected (i.e. I will do batch imports, don't need numerous users to share this ability, or have the ability built into Excel). Finally, would like to have a form or forms in the Access database to perform the export/imports.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Microsoft Windows, Access, Excel