Member Avatar for 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

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cutepinkbunnies
Member Avatar for cutepinkbunnies

Hi,

Could you provide us with a few sample rows of data. SSIS/DTS should be able to do the trick (commonly work with CSV data), we just need to see the data so we can put you in the right direction.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.