A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Batch import of image hyperlinks



 
 
Thread Tools Display Modes
  #1  
Old January 17th, 2005, 08:09 PM
Jojo
external usenet poster
 
Posts: n/a
Default Batch import of image hyperlinks

Whew!, I have 45,000+ images in a folder all named by a code (i.e.,
4567.tiff), I have an access table with descriptions for each of the photos.
I need to create a may to many relatioship, which I beleive I can do (since
one description can go to many photos and many descritpions can go to one
photo). From reading the boardsa I know I want to link images, but how do I
link by batch so I odn't have to manually enter in each hypelrink?....I know
just enough to be dangerous I guess because my end result is to have a visual
basic GUI accessing the access tables and displaying the images....sort of a
many-to-many description photo database.

Am I way over my head here?...I think I can handle the visual basic...just
dont know how to get all the file links into access....

If I am over my head...how much am I looking to spend ...ballpark ...for
someone to do this real fast?...I am a dental school student trying to get a
patient history presetnation done that will blow the professors socks off!

Thanks in advance!
--
Jojo--just treading water
  #2  
Old January 17th, 2005, 10:35 PM
John Nurick
external usenet poster
 
Posts: n/a
Default

Hi Jojo,

I guess the filenames must be in your table already, because without
that there's no way of knowing which description goes with which photo.
The following links show ways of handling images stored in external
files:

http://www.mvps.org/access/forms/frm0030.htm
http://www.datastrat.com/DataStrat2.html
http://accdevel.tripod.com/imaging.htm

For the "descriptions", it's hard to make firm suggestions without
knowing what's in your existing table. The kind of structure one would
expect in an image database is something like this (* indicates a field
is, or is in, the primary key):

tblImages
ImageID*
Title
Description
FileName
Date
Author
CopyrightHolder
CopyrightInformation

tblKeywords
Keyword* - e.g. "Fish", "Flesh", "Red", "Herring"

tblImagesKeywords (this is what implements the M:M relationship)
ImageID*
Keyword*

Are you thinking of parsing each description into a set of keywords?


On Mon, 17 Jan 2005 11:09:03 -0800, "Jojo"
wrote:

Whew!, I have 45,000+ images in a folder all named by a code (i.e.,
4567.tiff), I have an access table with descriptions for each of the photos.
I need to create a may to many relatioship, which I beleive I can do (since
one description can go to many photos and many descritpions can go to one
photo). From reading the boardsa I know I want to link images, but how do I
link by batch so I odn't have to manually enter in each hypelrink?....I know
just enough to be dangerous I guess because my end result is to have a visual
basic GUI accessing the access tables and displaying the images....sort of a
many-to-many description photo database.

Am I way over my head here?...I think I can handle the visual basic...just
dont know how to get all the file links into access....

If I am over my head...how much am I looking to spend ...ballpark ...for
someone to do this real fast?...I am a dental school student trying to get a
patient history presetnation done that will blow the professors socks off!

Thanks in advance!


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
  #3  
Old January 17th, 2005, 11:13 PM
Jojo
external usenet poster
 
Posts: n/a
Default

thanks for the reply...the filename are not in my table ...that is my main
problem ...I have the descriptions but thqt is it....I need to populate the
table with 45,000+ links to photos within a file on my desktop...I can only
see how access lets you type in one hyperlink at a time.....

"John Nurick" wrote:

Hi Jojo,

I guess the filenames must be in your table already, because without
that there's no way of knowing which description goes with which photo.
The following links show ways of handling images stored in external
files:

http://www.mvps.org/access/forms/frm0030.htm
http://www.datastrat.com/DataStrat2.html
http://accdevel.tripod.com/imaging.htm

For the "descriptions", it's hard to make firm suggestions without
knowing what's in your existing table. The kind of structure one would
expect in an image database is something like this (* indicates a field
is, or is in, the primary key):

tblImages
ImageID*
Title
Description
FileName
Date
Author
CopyrightHolder
CopyrightInformation

tblKeywords
Keyword* - e.g. "Fish", "Flesh", "Red", "Herring"

tblImagesKeywords (this is what implements the M:M relationship)
ImageID*
Keyword*

Are you thinking of parsing each description into a set of keywords?


On Mon, 17 Jan 2005 11:09:03 -0800, "Jojo"
wrote:

Whew!, I have 45,000+ images in a folder all named by a code (i.e.,
4567.tiff), I have an access table with descriptions for each of the photos.
I need to create a may to many relatioship, which I beleive I can do (since
one description can go to many photos and many descritpions can go to one
photo). From reading the boardsa I know I want to link images, but how do I
link by batch so I odn't have to manually enter in each hypelrink?....I know
just enough to be dangerous I guess because my end result is to have a visual
basic GUI accessing the access tables and displaying the images....sort of a
many-to-many description photo database.

Am I way over my head here?...I think I can handle the visual basic...just
dont know how to get all the file links into access....

If I am over my head...how much am I looking to spend ...ballpark ...for
someone to do this real fast?...I am a dental school student trying to get a
patient history presetnation done that will blow the professors socks off!

Thanks in advance!


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

  #4  
Old January 18th, 2005, 06:09 AM
John Nurick
external usenet poster
 
Posts: n/a
Default

If the filenames are not in your table, how do *you* know which
descriptions apply to which photos?

To get the filenames into a table, do this:

1) Open a command prompt (MS-DOS window); usually this is in
Start|Programs|Accessories.

2) Use the CD command to navigate to the folder with the photos, e.g.
CD "C:\Documents\Dental photos"

3) Use the command
DIR *.jpg /B "Photo names.txt"

This creates a textfile containing the names which you can import into
Access. Then you presumably face the happy task of creating potentially
hundreds of thousands of links between files and descriptions...



On Mon, 17 Jan 2005 14:13:03 -0800, "Jojo"
wrote:

thanks for the reply...the filename are not in my table ...that is my main
problem ...I have the descriptions but thqt is it....I need to populate the
table with 45,000+ links to photos within a file on my desktop...I can only
see how access lets you type in one hyperlink at a time.....

"John Nurick" wrote:

Hi Jojo,

I guess the filenames must be in your table already, because without
that there's no way of knowing which description goes with which photo.
The following links show ways of handling images stored in external
files:

http://www.mvps.org/access/forms/frm0030.htm
http://www.datastrat.com/DataStrat2.html
http://accdevel.tripod.com/imaging.htm

For the "descriptions", it's hard to make firm suggestions without
knowing what's in your existing table. The kind of structure one would
expect in an image database is something like this (* indicates a field
is, or is in, the primary key):

tblImages
ImageID*
Title
Description
FileName
Date
Author
CopyrightHolder
CopyrightInformation

tblKeywords
Keyword* - e.g. "Fish", "Flesh", "Red", "Herring"

tblImagesKeywords (this is what implements the M:M relationship)
ImageID*
Keyword*

Are you thinking of parsing each description into a set of keywords?


On Mon, 17 Jan 2005 11:09:03 -0800, "Jojo"
wrote:

Whew!, I have 45,000+ images in a folder all named by a code (i.e.,
4567.tiff), I have an access table with descriptions for each of the photos.
I need to create a may to many relatioship, which I beleive I can do (since
one description can go to many photos and many descritpions can go to one
photo). From reading the boardsa I know I want to link images, but how do I
link by batch so I odn't have to manually enter in each hypelrink?....I know
just enough to be dangerous I guess because my end result is to have a visual
basic GUI accessing the access tables and displaying the images....sort of a
many-to-many description photo database.

Am I way over my head here?...I think I can handle the visual basic...just
dont know how to get all the file links into access....

If I am over my head...how much am I looking to spend ...ballpark ...for
someone to do this real fast?...I am a dental school student trying to get a
patient history presetnation done that will blow the professors socks off!

Thanks in advance!


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
  #5  
Old January 18th, 2005, 02:57 PM
Jojo
external usenet poster
 
Posts: n/a
Default

That helps a ton..thanks

"John Nurick" wrote:

If the filenames are not in your table, how do *you* know which
descriptions apply to which photos?

To get the filenames into a table, do this:

1) Open a command prompt (MS-DOS window); usually this is in
Start|Programs|Accessories.

2) Use the CD command to navigate to the folder with the photos, e.g.
CD "C:\Documents\Dental photos"

3) Use the command
DIR *.jpg /B "Photo names.txt"

This creates a textfile containing the names which you can import into
Access. Then you presumably face the happy task of creating potentially
hundreds of thousands of links between files and descriptions...



On Mon, 17 Jan 2005 14:13:03 -0800, "Jojo"
wrote:

thanks for the reply...the filename are not in my table ...that is my main
problem ...I have the descriptions but thqt is it....I need to populate the
table with 45,000+ links to photos within a file on my desktop...I can only
see how access lets you type in one hyperlink at a time.....

"John Nurick" wrote:

Hi Jojo,

I guess the filenames must be in your table already, because without
that there's no way of knowing which description goes with which photo.
The following links show ways of handling images stored in external
files:

http://www.mvps.org/access/forms/frm0030.htm
http://www.datastrat.com/DataStrat2.html
http://accdevel.tripod.com/imaging.htm

For the "descriptions", it's hard to make firm suggestions without
knowing what's in your existing table. The kind of structure one would
expect in an image database is something like this (* indicates a field
is, or is in, the primary key):

tblImages
ImageID*
Title
Description
FileName
Date
Author
CopyrightHolder
CopyrightInformation

tblKeywords
Keyword* - e.g. "Fish", "Flesh", "Red", "Herring"

tblImagesKeywords (this is what implements the M:M relationship)
ImageID*
Keyword*

Are you thinking of parsing each description into a set of keywords?


On Mon, 17 Jan 2005 11:09:03 -0800, "Jojo"
wrote:

Whew!, I have 45,000+ images in a folder all named by a code (i.e.,
4567.tiff), I have an access table with descriptions for each of the photos.
I need to create a may to many relatioship, which I beleive I can do (since
one description can go to many photos and many descritpions can go to one
photo). From reading the boardsa I know I want to link images, but how do I
link by batch so I odn't have to manually enter in each hypelrink?....I know
just enough to be dangerous I guess because my end result is to have a visual
basic GUI accessing the access tables and displaying the images....sort of a
many-to-many description photo database.

Am I way over my head here?...I think I can handle the visual basic...just
dont know how to get all the file links into access....

If I am over my head...how much am I looking to spend ...ballpark ...for
someone to do this real fast?...I am a dental school student trying to get a
patient history presetnation done that will blow the professors socks off!

Thanks in advance!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Attn Sprinks -need help on second half -Batch part babs Using Forms 2 December 10th, 2004 01:29 AM
pptimport - batch image import - need version for PPT 97 Dilly Powerpoint 1 August 19th, 2004 11:53 PM
Import Image Problem (Invisible) Kendo General Discussion 2 July 31st, 2004 10:05 PM


All times are GMT +1. The time now is 10:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.