Uploading Excel File data into SQL database via a website

[wisheschoice]

[FONT=&quot]I am using php to develop my website and I need to be able to browse for and upload an Excel sheet. I then need to store the information in an SQL database.
I realise this is an relatively open question but I am have looked for information on how to do this and have not got very far. Storing the data in the SQL database is fine but I am not sure how to upload the spreadsheet such that it can be read by the website.
If anyone can point me in the right direction I would be grateful.
[/FONT][FONT=&quot]Here my web page is: awesome birthday wishes
[/FONT]

 

[ScottR]

It's been a number of years since I did something similar. If I recall correctly for my particular implementation it was sufficient to add code to my Excel book that allowed the submission of form data automatically (albeit to a MySQL database). It was far from optimal and not the approach I'd take now.

There were and are several PHP libraries available for reading from Excel files. You might want to investigate here https://phpexcel.codeplex.com/

 

[John_w]

I am using php to develop my website and I need to be able to browse for and upload an Excel sheet. I then need to store the information in an SQL database.
I realise this is an relatively open question but I am have looked for information on how to do this and have not got very far. Storing the data in the SQL database is fine but I am not sure how to upload the spreadsheet such that it can be read by the website.
If anyone can point me in the right direction I would be grateful.
Here my web page is: awesome birthday wishes

To upload a file you first need a HTML form with enctype="multipart/form-data", something like this:

< form enctype="multipart/form-data" action="upload_file.php" method="POST" >
Select a file to upload: 
< input type="submit" name="submit" value="Upload File" / >
< /form >

For the VBA side, you construct the form data string containing the file contents, and send it in a "POST" request using either IE, XMLhttp or WinHttpRequest to the web page containing the form to upload the file. See Post binary data to URL from WSH/ASP/VBA/VBScript. And there is a routine for constructing the form data (binary because it is an Excel file) at Automatic file upload using IE+ADO without user interaction - VBSscript.