Batch upload of data from a PC to MSaccess db.
Posted on 2001-06-14
I have an ASP input form for people to add a record to my database. I now want to give people a 'batch submit' option, where they can add a number of records at once.
People using this option will already have the data, most likely on an excel spreadsheet. So I think I will give them a preformatted spreadsheet to use. Then online, I want a way where they can point to the file on their own PC and upload it into the online database. Any ideas, suggestions/examples of how to go about this?