Importing Photographs

S

Sam9

How do I import large numbers of photographs into separate records without
cutting and pasting or writing code.
 
B

Bill Mosca

Microsoft has finally gotten away from storing images in tables. You can see
that Northwind that ships with Access 2003 no longer has the employee
pictures in the Employee table.

The preferred method is to store file paths that point to the image files.
It will save a lot of bloat and make it easier to maintain.

Getting all the files from a folder into a table is a snap using the Dir()
function.
 
N

Neil

Sam,

Inserting pictures into your database is definately not recommended as it
can lead to huge database 'bloating', the recommended method is to store your
pictures in a known location, and have an entry for each record that records
the pathname to the picture.

The whole process is too long to explain here, but check out the Access
pages at my website where you will see a tutorial on how to do this - there
is a little code involved, but there is also a sample database that you can
download and paste into your own application, so that should keep the work
down to much for you.

HTH

Neil
www.nwarwick.co.uk
 
Top