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.
| Author |
Topic |
|
sagscorp22
Starting Member
6 Posts |
 Posted - 2004-10-08 : 14:24:28
|
| Hello friends,I wonder if anybody is aware of any tool to map MS Word to MS Excel or to MS SQL server.I want to map some documents in standard tabular format to my SQL database.I would highly appreciate if anyone could help me.Thanks,Sag |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-08 : 14:27:14
|
| What do you mean by map? Do you want the documents stored inside SQL Server? If so, this is highly not recommended.Tara |
 |
|
|
sagscorp22
Starting Member
6 Posts |
Posted - 2004-10-08 : 15:20:54
|
| Hi,I do not want to store the document inside the sql database.I want the different fields of the table in the document to be stored in a sql table.Any help is appreciated.Sag |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-08 : 15:21:35
|
| I believe you can use linked servers for this. I've never done it, but I believe you can select Word as one of the data sources.Tara |
|
|
|
sagscorp22
Starting Member
6 Posts |
Posted - 2004-10-08 : 16:03:48
|
| The Word document is not part of the provided data sources.Do you know if there is any way.ThanksSag |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-08 : 16:49:27
|
| If you can move the Word table into Excel, then you'd be able to use a linked server.How many rows are we talking about?Tara |
|
|
|
sagscorp22
Starting Member
6 Posts |
Posted - 2004-10-08 : 17:03:17
|
| I have to map multiple docs.It can have any no of rows from 1 to 100 each approximately.I tried opening the doc using excel I could not do it.Is there any way of converting doc into xls?Thanks,Sag |
|
|
|
|
|
|
Tool to map MS Word to MS Excel or MS SQL server