I have a question bank in the word file, and I want to import this file into my database,
in my database i have 2 tables Table 1 -> question Table 2 -> options
so if I import this file to the database questions in the word file are stored in the table -> question, and the options of the question will be stored in the table -> options
maybe someone can solve it please
I was completed once this type of job like explain below:-
Take a look at the screenshot the possible format into MySQL import database
So i think first convert word file into csv format online
After that, you can import the CSV file easily to your MySQL database https://prnt.sc/hgn272 check screenshot if you are going to import data direct your existing tables
The 2nd way to import word files with coding: http://webcheatsheet.com/php/create_word_excel_csv_files_with_php.php
Thanks