Insert File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacky - 16 Jan 2007 07:00 GMT

In MS Access,

currentdb.execute "insert into [table1] ([Name],[ID],[Img]) values
('Amy',23,'C:\testscore.pdf')"

it cannot insert the file (ole object).
How to insert the file (ole object) using VBA?

Reply to this Message

Douglas J. Steele - 16 Jan 2007 12:36 GMT

You'll have to use the AppendChunk method.

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/o
utput/F1/D2/S5A265.asp?frame=true
http://msdn2.microsoft.com/en-us/library/ms678200.aspx

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> In MS Access,
>
[quoted text clipped - 3 lines]
> it cannot insert the file (ole object).
> How to insert the file (ole object) using VBA?

Reply to this Message