{"id":298,"date":"2011-08-22T03:57:13","date_gmt":"2011-08-22T03:57:13","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=298"},"modified":"2026-07-25T04:11:23","modified_gmt":"2026-07-25T04:11:23","slug":"how-to-export-sql-server-query-results-to-access","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mssqltoaccess\/how-to-export-sql-server-query-results-to-access.html","title":{"rendered":"How To Export Sql Server Query Results To Access"},"content":{"rendered":"<p>First, you need <a href=\"http:\/\/www.withdata.com\/down\/MsSqlToAccess.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 MsSqlToAccess.<\/p>\n<p>MsSqlToAccess is a software that export Sql Server query results to Access.<\/p>\n<p style=\"color: blue; font-weight: bold;\">Export Sql Server Query Results To Access &#8211; 4 Steps<\/p>\n<p>Click Import &#8211; Import From Query button.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/import-query-button.gif\" alt=\"start export\" width=\"317\" height=\"133\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>1. Show &#8220;Import Form Query&#8221; Form, input query, click &#8220;Get Fields&#8221; button.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/db-to-access-query-input.gif\" alt=\"input Sql Server query to export\" width=\"968\" height=\"702\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>2. Config target table and &#8220;Save Type&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/db-to-access-query-target.gif\" alt=\"choice Access table to save data\" width=\"968\" height=\"703\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>3. Config Fields.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/db-to-access-query-fields.gif\" alt=\"config fields\" width=\"968\" height=\"703\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>4. Click Import button, Show export progress.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/dbtodb\/db-to-access-query-import.gif\" alt=\"extract Sql Server query data to Access\" width=\"968\" height=\"703\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<hr style=\"clear: both; margin: 10px,0;\" \/>\n<p><a href=\"\/mssqltoaccess.html\">More about MsSqlToAccess<\/a> &#8211; the tool to export SQL Server data to Access.<\/p>\n<div style=\"clear: both;\"><span style=\"padding-right: 20px;\">30-day free trial <a href=\"http:\/\/www.withdata.com\/down\/MsSqlToAccess.exe\"><img decoding=\"async\" src=\"\/images\/btn_download_green.gif\" alt=\"Download MsSqlToAccess\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <\/span>US$79.00 <a href=\"\/purchase_mssqltoaccess.html\"><img decoding=\"async\" src=\"\/images\/btn_buynow_green.gif\" alt=\"Buy MsSqlToAccess\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>First, you need and install MsSqlToAccess. MsSqlToAccess is a software that export Sql Server query results to Access. Export Sql Server Query Results To Access &#8211; 4 Steps Click Import &#8211; Import From Query button. 1. Show &#8220;Import Form Query&#8221; Form, input query, click &#8220;Get Fields&#8221; button. 2. Config target table and &#8220;Save Type&#8221;. 3. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[7,35,26,163,1321,317,396,395],"class_list":["post-298","post","type-post","status-publish","format-standard","hentry","category-mssqltoaccess","tag-access","tag-export-query-results","tag-mssql","tag-mssql-export-database","tag-sql-server","tag-sql-server-export","tag-sql-server-export-query","tag-sql-server-export-query-to-access"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/298","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=298"}],"version-history":[{"count":9,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/298\/revisions"}],"predecessor-version":[{"id":19761,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/298\/revisions\/19761"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}