Simple SQL7 db, need to upload data from an Excel Spreadsheet via an ASP page. The data from the Excel file will need to be uploaded from the client to two different tables, using the contactId as primary key. All uploads will be "inserting" new records to two tables in SQL(users won't do it very often). tblContacts (SQL) will receive customer info, tblDeals(SQL) will receive "deal info".
One Excel File Example:
Excel Fields Imports To
FirstName [login to view URL]
LastName [login to view URL]
Address [login to view URL]
etc...etc..etc..
DealDate [login to view URL]
Profit [login to view URL]
etc.. etc..
Will need to limit the upload to a "certain" file size, etc. etc.
More details as needed.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
## Platform
ASP, MSSQL7 db, IIS