Small CSV conversion and reporting project
1. upload button (upload excell worksheet, has 9 columns and about 20,000 rows) - and insert into Access
2. important fields are id, first name, last name, address, city, state, postal, telephone
3. need reporting and saving reports back to excel
4. reports needed:
4.1 group all phone numbers that are the same - in the name field list all names
4.2 same as above but with phone and address that is the same
4.3 same as above but with postal code
4.4 text box to search/filter or to enter in ID numbers for grouping or names for grouping and then enter in group name and then when finished filter the main list and create a sub list in a new table for that group - can have many groups of data and must be able to edit/add on to them
4.5 Export all information to Excell
Need this within 2 days and must be in Asp.net and MS Access