Uploading Excel File data into SQL database via a website

awesome wishes

Prominent
Feb 14, 2017
1
0
510
Best answers
0
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:[link removed]
 

Ralston18

Dignified
Moderator
Oct 11, 2014
2,396
0
15,310
Best answers
966
Most databases and spreadsheets share common data formats for importing and exporting.

However, if you wish to directly provide a working Excel spreadsheet then that spreadsheet will need to be copied to a directly accessible folder via the webpage and downloadable accordingly. End user will need to have Excel available.

Or you could set up it up that the website would download the data as, for example .csv (comma separated values) that the end user would download and import to Excel.

Most sites with data offer the end user a selection of formats to chose from. Then your webpage accesses the data and exports it in that format.

Here is a current link to provide some additional insight and options:

https://www.thoughtco.com/creating-dynamic-web-pages-microsoft-access-1019971

Plan it out step by step and then start your development working one step at a time.

Visit other similar websites: you can often see the code behind the page - that will help you understand the mechanics of it all.



 
Thread starter Similar threads Forum Replies Date
H Apps General Discussion 0
N Apps General Discussion 2
M Apps General Discussion 5
U Apps General Discussion 1
D Apps General Discussion 2
N Apps General Discussion 1
G Apps General Discussion 1
B Apps General Discussion 0
A Apps General Discussion 1
B Apps General Discussion 1
C Apps General Discussion 2
A Apps General Discussion 1
A Apps General Discussion 1
A Apps General Discussion 5
WyomingKnott Apps General Discussion 1
P Apps General Discussion 2
R Apps General Discussion 1
S Apps General Discussion 1
FarNerdy Apps General Discussion 13
joe904 Apps General Discussion 3

Similar threads


ASK THE COMMUNITY

TRENDING THREADS