Importing Data from Excel with Pictures/Images

[apf500]

Hi! Have tried to find info on this but to no avail. I have currently set up a main db which links to a separate db containing photos of pupils at my school. The photos db is very simple with one table containing the fields [UPN] and [Photo]. The former is primary key, the second an OLE field. All of the UPNs and Photos are stored in an Excel file which is an exact version of how I want my table to look. However when I import my Excel workbook, the photos are not imported. I have tried everything on this one including importing from HTML - please help!!!

Alex

 

[boblarson]

However when I import my Access workbook, the photos are not imported.

What do you mean "import my Access workbook?" Access doesn't have workbooks. Excel does.

 

[apf500]

It's late... I mean Excel workbook

 

[boblarson]

If you are trying to import FROM Excel into Access, photos will not come along as they are not considered data in Excel. You would need to add them a different way into Access (and the best is a LINK to the pictures, not actually storing them IN the database).

 

[apf500]

OK... in which case how do I work it so that my "Photo" field provides a path and then my form collects that image and displays it?

If I do that can I then extract my photos from excel to jpgs and ensure that they are still linked to the appropriate primary key?

EDIT:

Worked out how to get my photo to display a link - but how can I extract my images from the excel file and make sure that their extracted name goes into my excel workbook?

Cheers

 

[mcclunyboy]

hi what version of access are you using?

Access 2007 allow you to create fields of type "attachment" which will solve your problem for you.

Another way is to use your OLE Object as the field type and just drag and drop the relevant pictures into the correct records

Then when you open the form with a label or whatever it should display the picture (trying this quickly worked fine with JPEG's on my machine but not with bmp for some reason)