[shashkun]

hii i wanted to insert questions, options and correct answer in the database(Multiple choice questions). I have around 8000 questions to be inserted. I tried with copying entire content from word into notepad and provided delimiters for questions and answers but the entire question appears in a single line(it is big problem when question size is big)in the data base which i dont want to be ///

Could anyone of you help me out?

Note: We can insert the data from excel sheet into database but copying each and every question and options from word to excel is also hectic. If there is any other way please help me out.

shashikanth kuntla

[Atli]

Hi.

So, basically, you have 8000 questions, each with multiple answers, in a Word document. And you want this into a MySQL database?

How is this data formatted in your Word document?
What does you database structure look like?

You can use the LOAD DATA INFILE command to load data from a CSV file into a table, but that would require the file to be properly formatted.

[shasiti]

hi...im ct...i have the same problem like you.to import data from mysql to excel. if you get information to solve that's problem.can u tell me....

tq.
regards,
ct

[Atli]

Originally Posted by shasiti

hi...im ct...i have the same problem like you.to import data from mysql to excel. if you get information to solve that's problem.can u tell me....

tq.
regards,
ct

Hi.

Exporting data from MySQL into Excel is no problem. There are several ways to do that in fact.

Excel is able to read the files created by MySQL's SELECT INTO OUTFILE statmement, so you should be able to do something like:

Expand|Select|Wrap|Line Numbers

1. SELECT * FROM myTable
2. INTO OUTFILE '/path/to/file.ext'
3.  

And Excel should show that correctly.
(Excel 2008 does, at least)