Bulk upload of data
I am writing an ASP application, which requires a database containing a table of users. Each user has a last name, a first name, a username and a password. Each user can be added individually via my application. However, I want to be able to upload multiple users (say, about 100 at a time) using data held in a spreadsheet. i.e. I want to bypass my web application form, and upload the spreadsheet via a different form, and have the application grab that data and enter it into the database automatically.
Please can you advise on how I can do this?