Importing Question

[baz]

I know that photos are OLE objects and need to be either embedded or linked.

I have someone who wants me to build them a database and they have (for now)
3,500 images to match to 3,500 products. The images are names the UPC if the
item and the UPC itself will be a field in the data.

Is there a way to import these images (xxxxx.jpg) en mass to match up with
the UPC data field to save time from individually embedding or linking them?

Thanks in advance for any solutions\comments.

baz

 

[Roger Carlson]

The best way to handle pictures in Access is to leave them stored in the
file system, store only the path and filename in a table, and load them into
a form or report at runtime. On my website (www.rogersaccesslibrary.com),
is a small Access database sample called "Picture.mdb" which illustrates how
to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[baz]

Roger:

Thanks for your response. Bottonline though is I still have to manually
enter the path for each record correct?

 

[Roger Carlson]

Well, no. On my website, there is another sample called "PicturesLoad.mdb"
which will allow you to browse to a file to load the path into the database.
That's still one at a time, but faster than typing them.

But if you know which directory they're in, you could batch load the
path/filenames into the database. I have another sample called
"DirectoryList.MDB" which could be modified to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[baz]

Ok, I can handle that but how did you create the picture in the report? I
looked at properties and all it says is ImgStock and is embeded? How is the
"link" to the image file established to the "company" name?

baz

 

[Roger Carlson]

There were a couple of errant records in the table that should have been
deleted as they were linked to a drive on my system. The charts are simply
JPEGs. Nothing special about them. You should unzip the application to a
directory and use the Choose a Picture button to load them into the
database.

The name of the Image Control is ImgStock. After you load the pictures with
the button, the pictures get loaded into the form in the Current event of
the form.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[baz]

Roger:

Hate to keep bugging you but I tried what you suggested but the choose
picture file but there is no report in it. If I created a new database and
one of the fields was the path and one the picture file name, and the jpg's
reside in the same directory could this be concatonated to achieve the file
field?

How would you suggest I link the and show the photos in the for and the
file? I still see having to create an image box and having to manually link
it. I guess I'm just missing the "auto linking" of the box to the UPC number.
When I run a report I want the listing to be sequential by UPC and the
picture appear in the Detail section of the report. I would expect 7-10
"details" on each page.

Again, it's the linking portion I've hung up on.

Thanks for your patience.

baz

 

[Roger Carlson]

Well, in my sample there is code that defines the "path" as the path where
the database resides.

pathname = CurrentProject.Path

If you want a different path, you need to put that in the program.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L