|
aeryck -> File upload/import (9/13/2005 13:55:29)
|
Greetings all.
I am trying to make an online database that contains request histories for our contracted technicians. The requests are mailed in as an Excel file (using a standard blank template I made, thankfully). I have already made an Access VB Module that can import the contents of the spreadsheet into a database. It imports to an Access table, and then transfers the contents of that table to a MySQL database server.
What I want to do is this: Is there any way I can write a file upload page (ASP?) that will take the uploaded Excel file and automatically insert it into the MySQL Database? I've never worked with file uploads before, so I really don't even know where to begin with this.
Any input is greatly appreciated - even if someone can just point me in the right direction with where to begin I'd appreciate it.
Thanks,
//Aeryck
|
|
|
|
