Insert a .BMP image using jetSQL

[chillay]

Is there a basic SQL command to insert an image using Jet SQL.

I tried the following in Access 2007:


----
CREATE TABLE Experiment

(

Field1 COUNTER (40),

Field2 IMAGE

);

-----
INSERT INTO Experiment (Field2)
Values ('C:\Users\Cecelia Allison\Desktop\Addy.bmp');

----

The field comes up as Long binary data and the image will not show up in a form.

Thanks!

Chillay

 

[genomon]

No command, but here is the VBA to do the trick:

http://office.microsoft.com/en-us/access/HA011472041033.aspx

Illegitimi non carborundum.

 

[chillay]

Thank you genomon!

Chillay