Import OLE object from one table into Attachment field of another table

GrandMasterTuck

In need of medication
Local time
Today, 15:03
Joined
May 4, 2013
Messages
129
Hi folks, I have a really REALLY old database mdb with an OLE field, and I'm moving the records from that old system to a sparkly new system with an attachment field. How do I write the query to fetch those old OLE objects and move them into a new table's attachment field? I tried using an Insert Into statement, but I got an error about multivalue fields (which confused the heck out of me...).

Old table: [People table]
Old OLE: [Picture of face]

New table: [tblPersons]
New attachment field: [Photo]

Any ideas? Thanks so much!
 

Users who are viewing this thread

Back
Top Bottom