This project is to upload an excel file information into a SQL table. A simple download page with selection options is also required. Please read the Legal requirement for details.
## Deliverables
1. Upload an Excel file into a SQL table via a website, using asp.net. The back-end is SQL.
2. The Excel file can have multiple worksheets.
3. There are several columns in each worksheet and every column has a heading.
4. The upload needs to be dynamic, meaning it will upload all information, no matter how many columns in each worksheets. The key is to upload same column name into the matching table field name. For example, First Name column into First Name field. Of course the entire row (record) has to be tied together.
5. The download page should include date selection and city selection (city selection should be a List and allow multiple values.)
6. The output is a value of total records retrieved (no details).
7. Each worksheet should have the same columns. However, if different, the program should handle it since you will deal with the column names.
8. There is only one table to deal with.
9. You will only need to retrieve the total number of records based on the selection criteria. Email will be sent to the requestor and the admin with the query selection.
Sample Excel worksheet data:
Name.........Address.............City.........State
Mark Smith..123 Main Street..Atlanta.....GA
Jane Smith..123 Wall Street...New York..NY
"..." are spaces