Database development work.
1. merge data from three or four excel files into an existing database.
2. These tables should be linked via a primary key.
3. New data should be entered from an entry form for base data and the additional sheets.
4. Need a macro for updated the database with versions of these files to capture changes in comments, status and dates.
5. The old data needs to be stored as history.
6. I need several reports with the option to email copies to a distribution list or to a single recepient.
7. Need a way to post these reports to a sharepoint directory
8. Need these reports in HTML or XML format
