{"id":1364,"date":"2021-04-24T12:34:27","date_gmt":"2021-04-24T04:34:27","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1364"},"modified":"2021-04-24T17:41:35","modified_gmt":"2021-04-24T09:41:35","slug":"introducing-access-ole-import","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/04\/24\/introducing-access-ole-import\/","title":{"rendered":"Introducing Access OLE Import"},"content":{"rendered":"<p><a href=\"https:\/\/www.yohz.com\/aoi_details.htm\">Access OLE Import<\/a> is our new product that helps you upload files into OLE Object-type fields in Access and most major database engines (SQL Server, PostgreSQL, MariaDB\/MySQL etc), for use in the following scenarios:<\/p>\n<ul>\n<li>you are migrating data to a database that uses OLE Object fields<br \/>\nE.g. you have a new customer that require their data to be migrated to OLE Object fields in your database.\u00a0 <a href=\"https:\/\/www.yohz.com\/aoi_details.htm\">Access OLE Import<\/a> can upload the files into those fields easily.<\/li>\n<li>you need to modify the existing data then upload the changes back into the tables<br \/>\nE.g. you want to extract images from your database, then resize\/add watermarks, then upload these updated images.\u00a0 Use <a href=\"https:\/\/www.yohz.com\/staging_yohz\/siv8_details.htm\">SQL Image Viewer<\/a> to extract the images, modify them, then use <a href=\"https:\/\/www.yohz.com\/aoi_details.htm\">Access OLE Import<\/a> to upload the files.<\/li>\n<li>you need to update file links in the OLE Object fields<br \/>\nE.g. you have existing file links that are no longer valid, and want to update those file links.\u00a0 <a href=\"https:\/\/www.yohz.com\/aoi_details.htm\">Access OLE Import<\/a> can upload file links as well as embedded files.<\/li>\n<li>you want to convert embedded content to file links in OLE Object fields<br \/>\nUse <a href=\"https:\/\/www.yohz.com\/aoi_details.htm\">Access OLE Import<\/a> to easily upload file links to replace the existing embedded content.<\/li>\n<\/ul>\n<p>You can read more about Access OLE Import on this <a href=\"https:\/\/www.yohz.com\/aoi_details.htm\">page<\/a>, or <a href=\"https:\/\/www.yohz.com\/downloads\/sqlblobviewer\/SQLImageViewerSetup.zip\">download<\/a> a 14-day trial.<\/p>\n<p>See also:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.yohz.com\/blogs\/?p=1366\">using Access OLE Import<\/a><\/li>\n<\/ul>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2021\/04\/24\/introducing-access-ole-import\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2021\/04\/24\/introducing-access-ole-import\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Access OLE Import is our new product that helps you upload files into OLE Object-type fields in Access and most major database engines (SQL Server, PostgreSQL, MariaDB\/MySQL etc), for use in the following scenarios: you are migrating data to a database that uses OLE Object fields E.g. you have a new customer that require their [&hellip;]<\/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\/1364"}],"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=1364"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1364\/revisions"}],"predecessor-version":[{"id":1370,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1364\/revisions\/1370"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}