By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,490 Members | 1,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,490 IT Pros & Developers. It's quick & easy.

Creating databse to insert Multiple choice questions.

P: 1
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
Aug 17 '08 #1
Share this Question
Share on Google+
3 Replies


Atli
Expert 5K+
P: 5,058
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.
Aug 18 '08 #2

P: 2
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
Aug 20 '08 #3

Atli
Expert 5K+
P: 5,058
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)
Aug 20 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.