{"id":748,"date":"2011-09-07T14:49:25","date_gmt":"2011-09-07T14:49:25","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=748"},"modified":"2026-07-05T05:26:52","modified_gmt":"2026-07-05T05:26:52","slug":"csv-to-sql-server-wizard","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/txttosql\/csv-to-sql-server-wizard.html","title":{"rendered":"Wizard For Importing CSV Data To Sql Server"},"content":{"rendered":"<p>First, you need <a onclick=\"logClick('txttosql_ad_download_induce');\" href=\"http:\/\/www.withdata.com\/down\/TxtToSql.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 TxtToSql.<\/p>\n<p>TxtToSql is a tool to import CSV data to Sql Server database.<\/p>\n<p align=\"center\"><img decoding=\"async\" src=\"\/images\/temp\/csvtosql.gif\" alt=\"csv to sql server\" width=\"405\" height=\"118\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Using TxtToSql you can import CSV data to Sql Server easily and fast.<\/p>\n<p>&nbsp;<\/p>\n<h3>Wizard for importing txt (csv) data to Sql Server<\/h3>\n<p>Click &#8220;Wizard &#8211; Import From File&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/txttosql\/wizard_task.gif\" alt=\"CSV To Sql Server Wizard- task window\" width=\"545\" height=\"476\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Open a file.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/txttosql\/wizard_open_file.gif\" alt=\"CSV To Sql Server Wizard- open a file\" width=\"558\" height=\"402\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>2. Select a table and config fields.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/txttosql\/wizard_select_table.gif\" alt=\"CSV To Sql Server Wizard- select table\" width=\"558\" height=\"402\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>3. Preview data.<\/p>\n<p><img decoding=\"async\" src=\"\/images\/txttosql\/wizard_preview.gif\" alt=\"CSV To Sql Server Wizard- preview\" width=\"558\" height=\"402\" 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\/txttosql\/wizard_import.gif\" alt=\"CSV To Sql Server Wizard- import data\" width=\"558\" height=\"402\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>For repeatable task, you can click &#8220;Save Session&#8221; button to save config, then run it next time. see also: <a href=\"\/txttosql\/session.html\">Save and load session<\/a>.<\/p>\n<hr style=\"clear: both; margin: 10px,0;\" \/>\n<p><a title=\"more about csv to Sql Server wizard\" href=\"\/txttosql.html\">More information&#8230;<\/a><\/p>\n<div style=\"clear: both;\">\n<p><span style=\"padding-right: 20px;\">30-day free trial <a onclick=\"logClick('txttosql_ad_download_bottom');\" href=\"http:\/\/www.withdata.com\/down\/TxtToSql.exe\"><img decoding=\"async\" src=\"\/images\/btn_download_green.gif\" alt=\"Download TxtToSql\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a><\/span><span>US$59.95 <a onclick=\"logClick('txttosql_ad_purchase_bottom');\" href=\"\/purchase_txttosql.html\"><img decoding=\"async\" src=\"\/images\/btn_buynow_green.gif\" alt=\"Buy TxtToSql\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span>\u00a0<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>First, you need and install TxtToSql. TxtToSql is a tool to import CSV data to Sql Server database. Using TxtToSql you can import CSV data to Sql Server easily and fast. &nbsp; Wizard for importing txt (csv) data to Sql Server Click &#8220;Wizard &#8211; Import From File&#8221; at task dialog. then show the wizard. 1. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[78],"tags":[34,6,26,1321],"class_list":["post-748","post","type-post","status-publish","format-standard","hentry","category-txttosql","tag-csv","tag-import","tag-mssql","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/748","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=748"}],"version-history":[{"count":3,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/748\/revisions"}],"predecessor-version":[{"id":27040,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/748\/revisions\/27040"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}