{"id":302,"date":"2006-11-07T17:16:21","date_gmt":"2006-11-07T15:16:21","guid":{"rendered":"http:\/\/www.wjst.de\/blog\/downloads\/convert-an-accessr-database-to-mysql-format\/"},"modified":"2007-12-06T11:22:07","modified_gmt":"2007-12-06T09:22:07","slug":"convert-an-accessr-database-into-mysql-format","status":"publish","type":"post","link":"https:\/\/www.wjst.de\/blog\/sciencesurf\/2006\/11\/convert-an-accessr-database-into-mysql-format\/","title":{"rendered":"Convert an Access(R) database into mySQL format"},"content":{"rendered":"<p>That should be a pretty straightforward task: Open in Access(R) the export function, select ODBC and send the tables to your local MySQL installation. This fails, however, on my system without any useful error message.<\/p>\n<p>Access2MySQL(R) of DMSoft(R) does the job, costs 55$. The trial version stops after transfering 10 datasets; nevertheless the newly created database allows an hazzle-free phpMyAdmin import of .csv exported data.<\/p>\n<p><a href=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2007\/12\/mysqlrev.png\" title='' data-rel=\"key-image-0\" data-rl_title=\"\" data-rl_caption=\"\"><img src='https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2007\/12\/mysqlrev.png' alt='mysqlrev.png' \/><\/a><\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"bottom-note\">\n  <span class=\"mod1\">CC-BY-NC Science Surf , accessed 05.04.2026<\/span>\n <\/div>","protected":false},"excerpt":{"rendered":"<p>That should be a pretty straightforward task: Open in Access(R) the export function, select ODBC and send the tables to your local MySQL installation. This fails, however, on my system without any useful error message. Access2MySQL(R) of DMSoft(R) does the job, costs 55$. The trial version stops after transfering 10 datasets; nevertheless the newly created &hellip; <a href=\"https:\/\/www.wjst.de\/blog\/sciencesurf\/2006\/11\/convert-an-accessr-database-into-mysql-format\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Convert an Access(R) database into mySQL format<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-302","post","type-post","status-publish","format-standard","hentry","category-genetics-biology"],"_links":{"self":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/comments?post=302"}],"version-history":[{"count":0,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/302\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/media?parent=302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/categories?post=302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/tags?post=302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}