{"id":1512,"date":"2021-10-05T16:44:48","date_gmt":"2021-10-05T08:44:48","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1512"},"modified":"2021-10-05T16:44:48","modified_gmt":"2021-10-05T08:44:48","slug":"updating-embedded-data-in-ole-object-fields","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/10\/05\/updating-embedded-data-in-ole-object-fields\/","title":{"rendered":"Updating embedded data in OLE Object fields"},"content":{"rendered":"

Do you need to update a batch of OLE Object fields, and you don’t want to have to update them individually using your application?\u00a0 Access OLE Import<\/a> can help you with such tasks.<\/p>\n

We had a user that needed to update a few thousand rows in an Access table, specifically an OLE Object field that stores a zip archive.\u00a0 He already had all the zip files ready, but did not want to have to update each record individually.<\/p>\n

So in SQL Image Viewer<\/a>, the existing records show up as zip archives embedded in OLE Object packages:<\/p>\n

\"\"<\/p>\n

The user already has the new zip files he wants to update the records with.\u00a0 Using Access OLE Import<\/a>, he just needs to prepare an upload definition file providing the key field value (ID<\/strong> in this case) and the OLE Object column to update the contents for (the quotations<\/strong> field).<\/p>\n

\"\"<\/p>\n

In Access OLE Import<\/a>, we enter the table to update together with this data file.<\/p>\n

\"\"<\/p>\n

And that’s it.\u00a0 Access OLE Import<\/a> will update the OLE Object fields with the new zip files accordingly.<\/p>\n

\"\"<\/p>\n

Note that you can also update any of the other text or numeric fields in your tables using Access OLE Import<\/a>.\u00a0 For e.g. if the user had wanted to update the address field, he only needed to enter the new values in the data file e.g.<\/p>\n

\"\"<\/p>\n

Learn more about Access OLE Import here<\/a>, or download<\/a> a 14-day trial now.\u00a0 Access OLE Import<\/a> can help you update batches of records easily, instead of having to update each record individually via your application.<\/p>\n

See here<\/a> on how you can update linked file locations using Access OLE Import<\/a>.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

Do you need to update a batch of OLE Object fields, and you don’t want to have to update them individually using your application?\u00a0 Access OLE Import can help you with such tasks. We had a user that needed to update a few thousand rows in an Access table, specifically an OLE Object field that […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[139],"tags":[140],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1512"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1512"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1512\/revisions"}],"predecessor-version":[{"id":1521,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1512\/revisions\/1521"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}