GrandMasterTuck
In need of medication
- Local time
- Today, 17:00
- 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!
Old table: [People table]
Old OLE: [Picture of face]
New table: [tblPersons]
New attachment field: [Photo]
Any ideas? Thanks so much!