I would like to develop an ASP page that the user can complete a form. I would like to query the excel file with data from the form and if a certain condition is met I would like to update the excel file. The excel file will be then uploaded.
This is for an online ordering system. It is a very long wided system that we use. Basically a manager asks us to add an account for online ordering. I then have to add data to an excel speadsheet. Data is drawn from our main company database (SAP) and stored in an excel file. A Formula is in the excel spreadsheet that performs a lookup on the data to test if the account details match from that what I have entered manually. I then have to perform a sort on all of the data then delete a column. Then upload the excel file for online ordering so that users can log in for online ordering.
Wow I can hear you scream! that's a shedload of work. I know. So basically if I want to add a user for online ordering I have to update the excel file with every username & login & upload. Suggestions would be most gratefully received.
Thanx in advance
Data from the main business database is downloaded from the SAP system to an excel file. The excel file has to be checked so that I know that account numbers match. I can then