{"id":3232,"date":"2014-04-24T06:42:35","date_gmt":"2014-04-24T06:42:35","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3232"},"modified":"2026-07-24T07:43:17","modified_gmt":"2026-07-24T07:43:17","slug":"batch-transfer-data-from-access-tables-to-postgresql-tables","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/accesstopostgres\/batch-transfer-data-from-access-tables-to-postgresql-tables.html","title":{"rendered":"Batch transfer data from Access tables to PostgreSQL tables"},"content":{"rendered":"<p>First, you need <a href=\"http:\/\/www.withdata.com\/down\/AccessToPostgres.exe\"><img decoding=\"async\" src=\"\/images\/btn_download_green.gif\" alt=\"download\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" \/><\/a> and install AccessToPostgres.<\/p>\n<p>AccessToPostgres is a tool to convert Access data to PostgreSQL.<\/p>\n<p>Using AccessToPostgres you can batch export Access tables data to PostgreSQL tables easily and fast.<\/p>\n<h2>Batch transfer data from Access tables To PostgreSQL tables<\/h2>\n<p>Click &#8220;Wizard &#8211; Import All Tables&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/wizard_a_1.gif\" alt=\"Batch import data from Access tables to PostgreSQL tables - Task Window\" width=\"635\" height=\"491\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Open Source.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/wizard_batch_source_no-schema.gif\" alt=\"Batch convert data from Access tables to PostgreSQL tables - Open Source schema\" width=\"567\" height=\"406\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>2. Select Destination.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/wizard_batch_target_has-schema.gif\" alt=\"Batch extract data from Access tables to PostgreSQL tables - select destination schema\" width=\"566\" height=\"407\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>3. Select tables to import.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/wizard_batch_select_tables.gif\" alt=\"Batch import data from Access tables to PostgreSQL tables - select tables\" width=\"567\" height=\"408\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>4. Import.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/wizard_batch_import.gif\" alt=\"Batch import data from Access tables to PostgreSQL tables - batch import\" width=\"568\" height=\"408\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"\/accesstopostgres\/\">More about AccessToPostgres &#8211; the tool to move data from Access to PostgreSQL<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"http:\/\/www.withdata.com\/down\/AccessToPostgres.exe\"><img decoding=\"async\" src=\"\/images\/btn_download_green.gif\" alt=\"Download AccessToPostgres\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$79.00 <a href=\"\/accesstopostgres\/purchase.html\"><img decoding=\"async\" src=\"\/images\/btn_buynow_green.gif\" alt=\"Buy AccessToPostgres\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>First, you need and install AccessToPostgres. AccessToPostgres is a tool to convert Access data to PostgreSQL. Using AccessToPostgres you can batch export Access tables data to PostgreSQL tables easily and fast. Batch transfer data from Access tables To PostgreSQL tables Click &#8220;Wizard &#8211; Import All Tables&#8221; at task dialog. then show the wizard. 1. Open [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[485],"tags":[7,763,764,758,759,1381,762,720,1370,760],"class_list":["post-3232","post","type-post","status-publish","format-standard","hentry","category-accesstopostgres","tag-access","tag-access-batch-export-to-postgresql","tag-access-batch-transfer-to-postgresql","tag-access-migrate-to-postgresql","tag-access-move-to-postgresql","tag-accesstopostgres","tag-batch-convert-access-data-to-postgresql","tag-database-migragte","tag-postgresql","tag-postgresql-import-access-data"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=3232"}],"version-history":[{"count":3,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3232\/revisions"}],"predecessor-version":[{"id":19746,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3232\/revisions\/19746"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}