how do I insert multiple word documents in an access table wdate

How do I insert multiple word documents in an access table w a date. My goal
is to save an outlook email as an image and upload it to an access table. The
email will provide historical updates to a project. There could be multiple
emails for one project.

You don't want to store images in the database. Your database file will
rapidly become large. Store all the images in a separate folder and save the
full path to the image in your table.
Your tables should look like:
TblProject
ProjectID
other project fields

TblProjectEmailImage
ProjectEmailImageID
ProjectID
ProjectEmailImagePath

Steve



"wiget" wrote in message
...
How do I insert multiple word documents in an access table w a date. My
goal
is to save an outlook email as an image and upload it to an access table.
The
email will provide historical updates to a project. There could be
multiple
emails for one project.

Wiget,

While you do not want to store images of anything in an Access database
becase it will cause bloating. You could store the actual eMail and it's
attachments. Sample code to do so...

http://www.dicks-clicks.com/excel/olRetrieving.htm

For the Word documents you could store a link to the document with which you
could Open/View the document.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
You don't want to store images in the database. Your database file will
rapidly become large. Store all the images in a separate folder and save
the full path to the image in your table.
Your tables should look like:
TblProject
ProjectID
other project fields

TblProjectEmailImage
ProjectEmailImageID
ProjectID
ProjectEmailImagePath

Steve



"wiget" wrote in message
...
How do I insert multiple word documents in an access table w a date. My
goal
is to save an outlook email as an image and upload it to an access table.
The
email will provide historical updates to a project. There could be
multiple
emails for one project.

Wiget,

While you do not want to store images of anything in an Access database
becase it will cause bloating. You could store the actual eMail and it's
attachments. Sample code to do so...

http://www.dicks-clicks.com/excel/olRetrieving.htm

For the Word documents you could store a link to the document with which you
could Open/View the document.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
You don't want to store images in the database. Your database file will
rapidly become large. Store all the images in a separate folder and save
the full path to the image in your table.
Your tables should look like:
TblProject
ProjectID
other project fields

TblProjectEmailImage
ProjectEmailImageID
ProjectID
ProjectEmailImagePath

Steve



"wiget" wrote in message
...
How do I insert multiple word documents in an access table w a date. My
goal
is to save an outlook email as an image and upload it to an access table.
The
email will provide historical updates to a project. There could be
multiple
emails for one project.