How to import .jpg files into my database

H

Hans

How can I import a photo (.jpg file) into my database ?
In my database I created a field named: photo (ole object)
If I convert the .jpg file into a bitmap file and use the .bmp it works.
But a .bmp file is larger than a .jpg file.
There must be a way to import a .jpg file in my database.
Please Help.
 
V

Van T. Dinh

Access is very inefficient with storing blobs, especially graphics like jpg
as jpg files are compressed and Access stores graphics uncompressed.

It is better store jpg files (and other graphic-format files) separately and
simply store the pathnames to the jpg files in Access.
 

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

jpg files not appearing 1
ole link to jpg 5
OLE Object Data Type Question 8
Linked OLE Object 3
Inserting a .jpg file into an OLE object 1
help with storing image files in access database and displaying imagefiles in reports (access 2000) 1
Macro to insert picture from specific folder 0
Insert .jpg file into Ole Object field record 8

Top