Excel to Database form
Was wondering if anyone could give me a a suggestion on HOW to craft a form, where the user can upload a Excel csv sheet and have it insert into the database? Any help would be appreciated.! :)
Was wondering if anyone could give me a a suggestion on HOW to craft a form, where the user can upload a Excel csv sheet and have it insert into the database? Any help would be appreciated.! :)
Well...
You would probably use Digital File Pro to upload the .csv to your server.
Then you would have to write php to open and parse the uploaded file and create an array of values.
Then you could use dataAssist insert to insert the first record in the array.
Then go back and add a loop around the insert to insert for each item in the array instead of just inserting once.
That is one way anyway.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.