I have several copies of an Excel form coming in by e-mail each day and I have someone printing them out and inputting some of the numerical data from them onto an Access database. I would like to automate this process somehow.
I have full access to both the Excel forms and the Access database so what I am after is maybe a module or a standalone program that will pull the data from the forms and drop it into the database or just advice on how to do it myself.
1) Complete and fully-functional working program(s) as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition
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).
Windows 2K & Windows XP