Insert File

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error on update table WHERE date comparison 0
Insert Values Of External Table Into Current Data Table 0
passing boolean variable value into SQL string 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Insert INTO Query 2
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Run-time error 3134, Syntax error in INSERT INTO statement 2
Problem with running an action query on a view 1

Top