I am in the process of converting a large data base from Access 2003 to
Access 2007 and them moving it to Sharepoint. The only issue I have is that
one of my linked tables has an OLE field (a small BMP). I found code on line
that did a great job of extracting each OLE field and saves them as BMP's
with the file name equal to the name of the primary key field in the record.
I now have a folder full of BMP's. I need to to attach each one to an
individual record in another table.

The BMP file names each match a field name in the record where it is to be
stored, so it would be fairly simple to manual attach one file to its
corresponding record, but I ma looking for code that would automate this
processs. Does anyone have any ideas?

On Fri, 24 Apr 2009 14:25:02 -0700, Rogers
<(E-Mail Removed)> wrote:

Can you please post a link to that extraction utility?

-Tom.


>I am in the process of converting a large data base from Access 2003 to
>Access 2007 and them moving it to Sharepoint. The only issue I have is that
>one of my linked tables has an OLE field (a small BMP). I found code on line
>that did a great job of extracting each OLE field and saves them as BMP's
>with the file name equal to the name of the primary key field in the record.
>I now have a folder full of BMP's. I need to to attach each one to an
>individual record in another table.
>
>The BMP file names each match a field name in the record where it is to be
>stored, so it would be fairly simple to manual attach one file to its
>corresponding record, but I ma looking for code that would automate this
>processs. Does anyone have any ideas?