如何将MS Word表复制到MS Access表中? [英] How to copy a MS Word table into an MS Access table?
问题描述
我有一个包含8列和大约300行的大型MS Word文档。某些列包含一个或多个屏幕图像。这些将需要嵌入或成为单独文件的超链接。我正在使用Access 2010。
I have a large MS Word document with 8 columns and about 300 rows. Some of the columns contain one or more screen images. These would need to be either embedded or become a hyperlink to a separate file.I'm using Access 2010.
我想将此文档转换为MS Access表并从中获取数据每列都成为MS Access表中的一个字段。
I's like to convert this document to an MS Access table and have the data from each column become a field in the MS Access table.
由于我参与的项目存在极端时间限制,我没有时间自己重新发明轮子。有没有人这样做并且知道怎么做?
Due to extreme time constraints on the project I'm involved in, I don't have time to reinvent the wheel myself. Has anyone done this and knows how?
推荐答案
没有内置的方法可以做到这一点,特别是没有图像。
There is no built-in way to do that, especially not with the images.
一个想法是将Word文档保存为另一种格式,可能是CSV或XML,但我担心图像。也许他们可以手动处理 - 300条记录不是太多。
One idea is to save the Word document to another format, maybe CSV or XML, but I am concerned about the images. Maybe they could be handled manually - 300 records is not too many.
另一种方法是使用自动化跟踪数据,以及https://msdn.microsoft.com / en-us / library / aa537149(v = office.11).aspx#officewordautomatingtablesdata_extractingdatafromatable
The other is to go after the data with Automation, along the lines of https://msdn.microsoft.com/en-us/library/aa537149(v=office.11).aspx#officewordautomatingtablesdata_extractingdatafromatable
这篇关于如何将MS Word表复制到MS Access表中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!