R
Rogers
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?
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?