I have 15 spreadsheet forms (MS Excel 2000) different formats containing different data. I have an existing MS Access 2000 file containing existing tables. I want to create an data mining (storage) and filtering application to get the needed data from the excel files and convert them into existing table formats in Access. The application should be able to read the 15 or so excel files, get the needed data cell depending on the column header name, perform a format check and export (append) to the existing MS Access file. The application should also be flexible so as to add or delete the 15 or so Excel files for any future revisions. E.B.T. [login to view URL]
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
MS Windows 98/NT/2000 MS Access 2000 MS Office 2000 (Excel)