{"id":3804,"date":"2025-08-29T05:29:16","date_gmt":"2025-08-29T05:29:16","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3804"},"modified":"2026-07-25T05:11:10","modified_gmt":"2026-07-25T05:11:10","slug":"copy-access-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/accesscopier\/copy-access-table.html","title":{"rendered":"Copy table in one Access or between Access databases"},"content":{"rendered":"<p>Want to clone  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  table, or copy data between  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  table?<\/p>\n<p>Using Withdata <a href=\"https:\/\/www.withdata.com\/db-copier\/\">DB Copier<\/a>, a desktop Access data transfer for Windows, MacOS, and Linux, Clone Access table, or copy data between Access table, in one Access, or between Access databases, Easy and Fast.<\/p>\n<ul>\n<li>Can run in <span id=\"gui\">GUI<\/span> mode, <a href=\"#copy\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in <a href=\"\/tools\/db-to-db\/copy-between-access-cmd\" target=\"_blank\">Command line<\/a>, for <a href=\"\/tools\/db-to-db\/copy-between-access-task\" target=\"_blank\">Scheduled Tasks<\/a> and Streams.<\/li>\n<li>Support <a href=\"\/tools\/db-to-db\/copy-between-access-windows\" target=\"_blank\">Windows<\/a>, <a href=\"\/tools\/db-to-db\/copy-between-access-linux\" target=\"_blank\">Linux<\/a>, and <a href=\"\/tools\/db-to-db\/copy-between-access-macos\" target=\"_blank\">macOS<\/a>.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata DBCopier<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DBCopier\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2 id=\"copy\">Copy table from one Access database to another<\/h2>\n<p><a href=\"#login\">Login to source and target Access<\/a> -> <a href=\"#source\">Choose source Access table<\/a> -> <a href=\"#target\">Set target Access table<\/a> -> <a href=\"#do\">Copy Access data<\/a><\/p>\n<p id=\"login\"> Choose source\/target Access database and logon.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/logon\/choose_access_logon.png\" alt=\"copy data between Access  - Choose Access and logon\" width=\"430\" height=\"443\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Click &#8220;Convert From Table&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_a_1.png\" alt=\"Load data from one Access table to another Access table - Task Window\" width=\"636\" height=\"479\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>then show the wizard.<\/p>\n<h3 id=\"source\">1. Open a source Access table.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_open_table_no-schema.png\" ALT=\"Import data from one Access table to another Access - Open Source\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3 id=\"target\">2. Select or create a destination Access table and config fields.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_select_table_no-schema.png\" ALT=\"Move data from one Access table to another Access - select table\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3>3. Preview data, Config rows.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/table-to-table-preview.png\" ALT=\"Transfer data from one Access table to another Access - preview\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3 id=\"do\">4. Copy Access table data.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/table-to-table-convert.png\" ALT=\"Send data from one Access table to another Access - copy\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<hr style=\"clear: both;\" \/>\n<p>More about <a href=\"\/tools\/db-to-db\/copy-between-access\">Access Copier<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata DBCopier<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DBCopier\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <span id=\"dbv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to clone Access table, or copy data between Access table? Using Withdata DB Copier, a desktop Access data transfer for Windows, MacOS, and Linux, Clone Access table, or copy data between Access table, in one Access, or between Access databases, Easy and Fast. Can run in GUI mode, Step by Step, just a few [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1454],"tags":[7,13307],"class_list":["post-3804","post","type-post","status-publish","format-standard","hentry","category-accesscopier","tag-access","tag-copy-table"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3804","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=3804"}],"version-history":[{"count":22,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3804\/revisions"}],"predecessor-version":[{"id":45110,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3804\/revisions\/45110"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}