Friday, March 30, 2012

importing word document into sqlserver

chapter1
Delegates officially are to nominate Cheney as the GOP's vice presidential candidate before he addresses the group Wednesday night.
chapter2
"I think that the vice president's speech tonight is going to be about big issues, the big issues of this campaign -- the war on global terror, the president's education policy, the fact that the economy is turning up again," she told CNN's "American Morning."
chapter3
She said she had known her husband since he was 14 and planned to share anecdotes that many people have not heard before in her introduction.
Chapter4
Maverick Democratic Sen. Zell Miller of Georgia is scheduled to deliver Wednesday's keynote address -- a role he also played at the 1992 Democratic National Convention, which nominated President Clinton.
Chapter5
In the earlier speech, Miller, then governor of Georgia, said that "for 12 dark years, the Republicans have dealt in cynicism and skepticism. They have mastered the art of division and diversion, and they have robbed us of our hope."

I wanted to import the above word doc into my sql server DB.
I have two columns in the table
1.Chaptereid
2.chapter_notes
chater1,chater2,chapte2,chapter3,chapter4 and chapter5 should go into chaptered column and the text followed by the chapter id should be imported into chapter_notes column.

So how can I import this document.

Thanks.Well...

I would say that if you want to work with "Data", you'll need to save the document as pure text or at least as an rtf..

To store a word doc, you'd need to store it in a text or image column...

So assuming you save it to text, I'd start by loadinging in to a table with 2 columns.

One that is an identity column and one thats varchar

However, there is no gaurentee that the rows will "load" themselves in the correct order.

But lets say they do, you could probably find the "row numbers" that make up the segements you are looking for...

Just don't trust it to be 100% all the time.

To 100% your document or text file would need to be tagged with their relative positions.

Also, you might want to look into your content...damn left wing drivel...|||Well...

I would say that if you want to work with "Data", you'll need to save the document as pure text or at least as an rtf..

To store a word doc, you'd need to store it in a text or image column...

So assuming you save it to text, I'd start by loadinging in to a table with 2 columns.

One that is an identity column and one thats varchar

However, there is no gaurentee that the rows will "load" themselves in the correct order.

But lets say they do, you could probably find the "row numbers" that make up the segements you are looking for...

Just don't trust it to be 100% all the time.

To 100% your document or text file would need to be tagged with their relative positions.

Also, you might want to look into your content...damn left wing drivel...

No comments:

Post a Comment