How do you export attachments on Access records?

[bburton]

I'm using a form in Access which was used as a bug tracker. The users
could update the record with an attachment. (The data type of the
field that is used for attachments is the OLE Object)

I need to export these records into Rational ClearQuest. I am able to
export and import the records correctly, but not the attachments.
There is an option to import attachments in ClearQuest, but I'm not
sure how to export them from Access to being with. The attachment
column is blank when I export the table in access.

I'm not exactly sure how this would work once the Access records with
attachments are exported, but I think I just need the column for the
attachment field to contain a link to where the file is located on my
PC.

Does anyone know how to export attachments?

Thanks,
Brad

[pietlinden]

eeeuwww yuck. saving the files in a common/shared directory and then
storing the UNC would have been better. Check out Stephen Lebans's
site - maybe he has an answer...

http://www.lebans.com/oletodisk.htm

the big problem with storing files as OLE is that your database bloats
something FIERCE. I would store LINKS to the files and just *format*
them in my forms as hyperlinks. If you use a UNC path like

\\SERVERNAME\DIRECTORY\FILENAME.EXT

then anyone with the proper application or viewer installed can read
the files.

Sorry for the oblique answer, but that's the best I can do for ya.