Trouble importing jpegs

D

Dante

I need to import an excel spreadsheet which has a column of jpeg image
(all the same size). The problem is that when I import this spreadshee
the column containing the jpeg images is empty. How can I import thes
images
 
J

John Nurick

You can't do this with the standard import routine.

I've never seen a worksheet with jpeg images actually in the cells, so I
guess that these are actually shapes on the worksheet that are aligned
with the cells in a column. If that's the case, I think you'll need to
write code that extracts the images from the cells' (or the worksheet's)
Shapes collections and puts them either into an OLE field in your table
or into files on disk ready for you to store their names and locations
in a text field.
 
Top