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...

Importing word doc into ms sql server2005 database

Could some1 pls help me, how do I import a word doc into a sql server database, and it mus t be displayed in a panel

I need to know how to do it, step by step

Thanx to all that help

The best way that I know of is to export the Word document as HTML and load that into a VARCHAR(MAX) column.

importing sql2005 database diagram to word doc

Hi I have a large database diagram and am only displaying the table names and
relationships. When I copy the diagram to the clipboard and paste it to a
word doc the diagram is hard to read because the letering on each table
appears quite small. I tried changing the zoom within management studio
prior to the copy but it has no effect. Any ideas or is there a specific
method of exporting the image other than just copy to clipboard and paste?
thanks.
--
Paul G
Software engineer.If you take a big diagram and squeeze it into a small space, I don't
know how to avoid the text getting small. I know that when I wanted
to print a diagram to a single page the approach I took was to expand
it to 200%, copy it, then past it into Irfanview and print from there.
I could also save it from there as a jpeg. I suppose you could try
that, and then see if placing the jpeg into the Word document works
any better, but I would not hold out much hope.
Roy Harvey
Beacon Falls, CT
On Fri, 25 Apr 2008 09:46:00 -0700, Paul
<Paul@.discussions.microsoft.com> wrote:
>Hi I have a large database diagram and am only displaying the table names and
>relationships. When I copy the diagram to the clipboard and paste it to a
>word doc the diagram is hard to read because the letering on each table
>appears quite small. I tried changing the zoom within management studio
>prior to the copy but it has no effect. Any ideas or is there a specific
>method of exporting the image other than just copy to clipboard and paste?
>thanks.|||thanks for the information. I ended up just using the table names to gain
some space and was able to move the objects around (closer together) within
SQL Server Management Studio. Have not heard of Irfenview, might have to
check it out.!
--
Paul G
Software engineer.
"Roy Harvey (SQL Server MVP)" wrote:
> If you take a big diagram and squeeze it into a small space, I don't
> know how to avoid the text getting small. I know that when I wanted
> to print a diagram to a single page the approach I took was to expand
> it to 200%, copy it, then past it into Irfanview and print from there.
> I could also save it from there as a jpeg. I suppose you could try
> that, and then see if placing the jpeg into the Word document works
> any better, but I would not hold out much hope.
> Roy Harvey
> Beacon Falls, CT
> On Fri, 25 Apr 2008 09:46:00 -0700, Paul
> <Paul@.discussions.microsoft.com> wrote:
> >Hi I have a large database diagram and am only displaying the table names and
> >relationships. When I copy the diagram to the clipboard and paste it to a
> >word doc the diagram is hard to read because the letering on each table
> >appears quite small. I tried changing the zoom within management studio
> >prior to the copy but it has no effect. Any ideas or is there a specific
> >method of exporting the image other than just copy to clipboard and paste?
> >thanks.
>|||On Fri, 25 Apr 2008 14:00:00 -0700, Paul
<Paul@.discussions.microsoft.com> wrote:
>Have not heard of Irfenview, might have to
>check it out.!
Irfanview is a free utility for viewing image files, but it also has
some manipulation ability such as changing resolution. A great
utility, but nothing unique.
Roy Harvey
Beacon Falls, CT

Importing MS Word Forms

I have some complex Word forms that need to be converted into reports. Are
there any tools for converting/importing Word to RDL format as you can't
paste into the desinger.
Thanks
Toby.SQL Server 2000 Reporting Services does not support this directly. You
might check to see if one of our partners is able to assist you:
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Toby" <toby.maillist@.exmlsystems.com> wrote in message
news:uMKD5gshEHA.1276@.TK2MSFTNGP09.phx.gbl...
> I have some complex Word forms that need to be converted into reports. Are
> there any tools for converting/importing Word to RDL format as you can't
> paste into the desinger.
> Thanks
> Toby.
>

Importing a word document into SQL Server

Hey all,
Does anyone know how I can import a word document into SQL server so
that it can be searchable using a web page (coldfusion or PHP)?
Or if anyone knows a simple way to make a word document searchable from
a web page, that would be great. Thanks!You would be better off using Index Server for this. Storing the document
in the database makes it no more searchable from a web page than would
storing the document on disk.
<simojo@.gmail.com> wrote in message
news:1139438036.600958.34280@.g43g2000cwa.googlegroups.com...
> Hey all,
> Does anyone know how I can import a word document into SQL server so
> that it can be searchable using a web page (coldfusion or PHP)?
> Or if anyone knows a simple way to make a word document searchable from
> a web page, that would be great. Thanks!
>