M
Mondou
I have about 5,000 Jpeg pictures that I am trying to link to an Access
database to create a catalog.
My database Table (tblPrice) contains STYLE# (Primary Key), DESCRIPTION
and PRICE.
My picture folder contains the pictures named after their STYLE#.
Instead of linking each picture one by one, I would like to importor
link the images by batch.
Since I am a newby with Access...but learning fast, could anyone show
me how to do this step by step.
I have read that I need to create a textfile containing the names of
the pictures (eg. 4270.jpg, 4271.jpg, ...). I have completed this and
the text file is in the PictureFolder. Since my picture folder will be
updated on a regular basis, I think that I am better off linking the
images than embedding them.
I thought of importing the text file into a new table (tblPictures)
with the following fields: STYLE# (Primary key) & PICTURE NAME (
STYLE#.jpg).
Secondly, could anyone tell me what VBA codes to use for this task?...
Thanks for any help
database to create a catalog.
My database Table (tblPrice) contains STYLE# (Primary Key), DESCRIPTION
and PRICE.
My picture folder contains the pictures named after their STYLE#.
Instead of linking each picture one by one, I would like to importor
link the images by batch.
Since I am a newby with Access...but learning fast, could anyone show
me how to do this step by step.
I have read that I need to create a textfile containing the names of
the pictures (eg. 4270.jpg, 4271.jpg, ...). I have completed this and
the text file is in the PictureFolder. Since my picture folder will be
updated on a regular basis, I think that I am better off linking the
images than embedding them.
I thought of importing the text file into a new table (tblPictures)
with the following fields: STYLE# (Primary key) & PICTURE NAME (
STYLE#.jpg).
picture files? ...how will Access know the path?From here, I'm confused; How will the program know where to get the
Secondly, could anyone tell me what VBA codes to use for this task?...
Thanks for any help