Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to import details from word template

Author  Topic 

cmjpc78
Starting Member

1 Post

Posted - 2006-03-02 : 08:50:42
Hi,

I have a word template document.I want to extract the details from the word document to sql table.Please help me how can i acheive this.
Thanks in advance.

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-03-06 : 17:39:09
It depends on how your document is structured. If it's built as a table it should be relatively easy, provided you know your way around the Word API.

You can get a table cell's value via the Word API like this:
thisdocument.Tables(1).Cell(1,2).range.Text


Obviously you'll need to write some sort of app/dts package to import your docs, but it shouldn't be too difficult.

HTH,

Tim
Go to Top of Page
   

- Advertisement -