Insert File

[Jacky]

In MS Access,

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

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

 

[Douglas J. Steele]

You'll have to use the AppendChunk method.

http://msdn.microsoft.com/archive/d...ice97/html/output/F1/D2/S5A265.asp?frame=true
http://msdn2.microsoft.com/en-us/library/ms678200.aspx