如何将附加的jpeg文件从Access导出到Word [英] How to export attached jpeg files from Access to Word

问题描述

我有工作VBA从Access数据创建Word文档，甚至可以将jpeg'插入到标题中，但jpeg位于C：驱动器上的文件夹中。


在Access数据库中插入现在是附件的相同jpeg的VBA是什么？客户想要数据库中的jpeg，这样它就可以从一台机器移动到另一台机器而无需重新分配jpegs的C：文件夹路径。


谢谢，

I have working VBA that creates Word documents from Access data and can even insert jpeg''s into the headers, but the jpegs are in a folder on the C: drive.

What is the VBA to insert the same jpegs that are now attachments in the Access database? The customer wants the jpegs in the database so it can move from machine to machine without reassigned the C: folder path for the jpegs.

Thanks,

推荐答案

我听说过可以在Access中处理的BLOB（二进制大对象），但对它们了解不多。这可能是开始寻找的方向。

I''ve heard of BLOBs (Binary Large OBjects) that can be handled in Access, but don''t know much about them. It may be the direction to start looking in though.

我知道Stephen Lebans当然 http://www.lebans.com/

已经完成了对Blob的工作，我不记得哪个是相关的标题，但我有和老的Mdb他的一个项目的版本。


斯蒂芬大约8年前就已经退休了，所以我认为他的大部分工作都是用Mdb格式的。


Phil

I Know Stephen Lebans certainly http://www.lebans.com/
has done works on Blobs, I can''t remember which was the relevant title, but I have and old Mdb version of one of his programs.

Stephen sadly retired about 8 years ago, so I think most of his work was in Mdb format.

Phil

我会检查出来的。感谢NeoPa和PhilOfWalton的回复。

I''ll check it out. Thanks for the replies NeoPa and PhilOfWalton.

这篇关于如何将附加的jpeg文件从Access导出到Word的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！