How to import .jpg files into my database

  • Thread starter Thread starter Hans
  • Start date Start date
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.
 
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.
 
Back
Top