{"id":10380,"date":"2022-05-10T07:28:29","date_gmt":"2022-05-10T07:28:29","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=10380"},"modified":"2022-05-10T07:28:29","modified_gmt":"2022-05-10T07:28:29","slug":"importexport-database-data-fromto-files-without-programming","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/dbloader\/importexport-database-data-fromto-files-without-programming.html","title":{"rendered":"Import\/Export database data from\/to files without programming"},"content":{"rendered":"<p>Want to load\/unload database data from\/to files?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/db-loader\/\">DBLoader<\/a>, you can load\/unload database data from\/to files easily and fast, just a few mouse clicks!<\/p>\n<p>You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF,  etc.<\/p>\n<p>You can export data to multiple types of file, such as SQL, TXT, CSV, TSV, Excel, JSON, XML, HTML, etc.<\/p>\n<p>Support multiple types of RDBMS, such as Access, DB2, DBF, MySQL, Oracle, PostgreSQL, SQL Server, SQLite, Amazon Redshift, Azure SQL, etc.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/db-loader\/db_types.png\" ALT=\"load\/unload database data - multiple types of RDBMS\" width=\"430\" height=\"473\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>Support Windows, Linux, macOS<\/p>\n<p>Here you can <a href=\"https:\/\/www.withdata.com\/db-loader\/download.html\">download<\/a> and install <a href=\"https:\/\/www.withdata.com\/db-loader\/\">DBLoader<\/a>.<\/p>\n<h2>Import\/Export database data from\/to files<\/h2>\n<p><b>Import<\/b>, you can import<\/p>\n<ul>\n<li>Load From File<\/li>\n<li>Load From Files (Folder)<\/li>\n<\/ul>\n<p>For example, import TXT files to table<\/p>\n<p><p> Click &#8220;Load From Files (Folder)&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/db-loader\/task-window.png\" ALT=\"load\/unload database data - task window\" width=\"819\" height=\"582\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>then show the wizard.<\/p>\n<p> Select a file type.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/select-file-type.png\" ALT=\"Batch import files data To databases - select file type\" width=\"547\" height=\"236\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then show the import wizard.<\/p>\n<p>1. Select a folder.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/folder-to-table-source.png\" ALT=\"Batch import files data to 1 table - select a folder\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>2. Config file parameters.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/folder-to-table-first.png\" ALT=\"Batch import files data to 1 table - config file parameters\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>3. Select a table and config fields.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/folder-to-table-target.png\" ALT=\"Batch import data from file to 1 table - select table\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>4. Preview data.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/folder-to-table-preview.png\" ALT=\"Batch import files data to 1 table - preview\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>5. Import to table or save sql script to file.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/folder-to-table-convert.png\" ALT=\"Batch import data from files to 1 table -  import data\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p><b>Export<\/b>, you can<\/p>\n<ul>\n<li>Unload From Table<\/li>\n<li>Unload From Query<\/li>\n<li>Unload All Tables<\/li>\n<li>Unload Similar Tables<\/li>\n<\/ul>\n<p>For example, export Collections to Excel files<\/p>\n<p><p>Click &#8220;Export All Collections&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/db-loader\/task-window.png\" ALT=\"load\/unload database data - task window\" width=\"819\" height=\"582\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Select file type.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/db-to-file\/select-file-type.png\" ALT=\"Export data from database Tables To Files - select file type\" width=\"529\" height=\"189\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>2. Select Tables.<\/p>\n<p><IMG SRC=\"https:\/\/www.withdata.com\/images\/db-to-file\/tables-to-files-source.png\" ALT=\"Export data from database Tables To Files - select tables\"><\/p>\n<p>3. Enter data folder.<\/p>\n<p><IMG SRC=\"https:\/\/www.withdata.com\/images\/db-to-file\/tables-to-files-target.png\" ALT=\"Export data from database Tables To Files - enter data folder\"><\/p>\n<p>4. Map.<\/p>\n<p><IMG SRC=\"https:\/\/www.withdata.com\/images\/db-to-file\/tables-to-files-map.png\" ALT=\"Export data from database Tables To Files - map\"><\/p>\n<p>5. Summary.<\/p>\n<p><IMG SRC=\"https:\/\/www.withdata.com\/images\/db-to-file\/tables-to-files-summary.png\" ALT=\"Export data from database Tables To Files - summary\"><\/p>\n<p>6. Export.<\/p>\n<p><IMG SRC=\"https:\/\/www.withdata.com\/images\/db-to-file\/tables-to-files-convert.png\" ALT=\"Export data from database Tables To Files - export\"><\/p>\n<p>You can schedule and automate this converting task by: <\/p>\n<p><p><a href=\"https:\/\/withdata.com\/db-loader\/cmd.html\" target=\"_blank\">1) Save session and create .bat file.<\/a><\/p>\n<p><a href=\"https:\/\/withdata.com\/dbtodb\/schedule-task.html\" target=\"_blank\">2) Set scheduled task.<\/a><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"https:\/\/www.withdata.com\/db-loader\/\">More about DBLoader &#8211; the tool to load\/unload database data to files<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"https:\/\/www.withdata.com\/db-loader\/download.html\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DBLoader\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$95.0 <a href=\"https:\/\/www.withdata.com\/db-loader\/purchase.html\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_buynow_green.png\" alt=\"Buy DBLoader\" width=\"154\" height=\"45\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to load\/unload database data from\/to files? Using DBLoader, you can load\/unload database data from\/to files easily and fast, just a few mouse clicks! You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc. You can export data to multiple types of file, such as SQL, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2769],"tags":[641,2766,2765,2767,2768],"class_list":["post-10380","post","type-post","status-publish","format-standard","hentry","category-dbloader","tag-database","tag-database-export","tag-database-import","tag-database-load","tag-database-unload"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10380","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=10380"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10380\/revisions"}],"predecessor-version":[{"id":10381,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10380\/revisions\/10381"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=10380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=10380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=10380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}