We want to create a user system where we can make a points list of volunteers in my office and we want to have all people in the office be able to update this via Excel or a similar program, and have it update into the MySQL database.
What is the most feasible way to do this, I dont know much about the formatting but didnt know if I should look into CSV or XML or something like that?:
Loading Excel Data Into A Database
Moderator: General Moderators
Or in tab delimited txt format.
Then you can use:
Then you can use:
Code: Select all
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;
There are 10 types of people in this world, those who understand binary and those who don't
Excel has a function "Export to tab delimited tex file" - no need to edit with Notepad.
Also, Excel has a function "Import from tab delimited tex file" ...
Also, Excel has a function "Import from tab delimited tex file" ...
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host
There are 10 types of people in this world, those who understand binary and those who don't