HT mine data from Word to SQL Server

M

Mark Davison

I need to be able to somehow mark parts of an existing
Word document, pull the marked data from the document and
map it into a table in SQL. I have seen information on
how to do it from Excel, but not for Word. Can you point
me in the right direction?
 
J

Jean-Guy Marcil

Mark Davison was telling us:
Mark Davison nous racontait que :
I need to be able to somehow mark parts of an existing
Word document, pull the marked data from the document and
map it into a table in SQL. I have seen information on
how to do it from Excel, but not for Word. Can you point

Dump the Word data in a temporary Excel file?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
M

Mark Davison

Thanks, but that is not an acceptable solution. Any
other ideas? Can I some how go through and easily mark
sections w/ Smart tags (each tag assosciated w/ a SQL
field and run something to pull these values and put them
in SQL based on the fields?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top