How can I Import data (text) from a word document into a SQL Server database?

Question

I have this huge Word document with data about contact details about people. There are close to 350000 such contact details that needs to be inserted into a database.

How do i do this? Do i convert it into XML and then to database, or should i use some scripting language to parse the word data and insert it into database?

Answer 1

Parse the Word document using some scripting language like Perl. Covert it into xml or txt. Once done you can very easily import the data into your database. Refer the following link for more help: Convert Word doc or docx files into text files?