从doc文件到sql的转换 [英] Conversion from doc files to sql

问题描述

大家好，

我有90个字的文档，并且其中包含很多数据.我想创建一种技术，通过该技术可以将Word文档转换为sql文档，然后将这些sql文档直接导入到数据库中.

这是示例文章，我在一个文档中有很多这样的文章:

================================================== ==============================
•经济学专栏作家展望未来

戴维·韦塞尔

http://online.wsj.com/article/SB10001424052970203899504577126544287069230.html?mod=ITP_pageone_1

经常有经济专栏作家被问到:您预计来年会有什么惊喜?专栏作家回答道，微笑着避免显得肿:如果我预料到了它们，那就不会感到惊讶.
一个更好的问题是:传统观念最有可能出错的地方是什么?
共识是，明年美国经济增长将太慢而无法迅速降低失业率.那么，什么可以使今年变得更好，又可能出什么问题呢?大卫·韦塞尔(David Wessel)参与了新闻中心.照片:Getty Images
共识是，美国经济将在2011年第四季度结束时(以年率计算为3.25％)比第三季度(1.8％)要强得多，但明年的增长速度将太慢(第一季度可能为2.25％)，因此无法实现失业迅速下降.

郑中山
================================================== ===============================

我想在datbase中将帖子标题转到标题字段，将文章链接转到网站字段，将文章摘录或说明转到文章字段，以此类推.

如果有人知道该怎么做，请帮助我.

谢谢

Hi every one,

I have 90 word documents and have a lot of data in them. I want to create a technique by which I can convert that word documents to sql documents and I directly import those sql documents to my database.

Here is sample Article I have many such articles in a single document:

=================================================================================
• An Economics Columnist Peers Into the Future

By DAVID WESSEL

http://online.wsj.com/article/SB10001424052970203899504577126544287069230.html?mod=ITP_pageone_1

Every so often, an economic columnist is asked: What surprises do you anticipate in the coming year? And the columnist replies, smiling to avoid seeming snarky: If I anticipated them, they wouldn''t be surprises.
A better question is this: Where is the conventional wisdom most likely to be wrong?
The consensus is that the U.S. economy will grow too slowly next year to bring unemployment down quickly. So what could make the year turn out better and what could go wrong? David Wessel weighs in on The News Hub. Photo: Getty Images
The consensus is that the U.S. economy will finish 2011 with a fourth quarter much stronger (perhaps 3.25% at an annual rate) than the third (1.8%) but will grow too slowly next year (perhaps 2.25% in the first quarter) to bring unemployment down quickly.

By JONATHAN CHENG
==================================================================================

I want that Post title go to title field, article link go to website field, article Excerpt or description goes to article field and so on in the datbase.

Please help me if anyone knows How to do this.

Thanks

推荐答案

没有任何要转换的内容，您只需要将其存储为正确的^ ].

There is nothing to convert, you just need to store it as the correct data type[^] in the database.

这篇关于从doc文件到sql的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！