Import Flat File wizard is a new feature implemented in SQL Server Management Studio (SSMS) v17.3 for importing a .csv or a .txt file into a SQL Server database.
导入平面文件向导是SQL Server Management Studio(SSMS)v17.3中实现的一项新功能,用于将.csv或.txt文件导入SQL Server数据库。
The latest SSMS version can be found on this link
在此链接上可以找到最新的SSMS版本
To invoke the Import Flat File wizard, go to Object Explorer, select a database you want to use to import data from a .csv or .txt file, right click and from the context menu, choose the Import Flat File option:
要调用导入平面文件向导,请转到对象资源管理器 ,选择要用于从.csv或.txt文件导入数据的数据库,右键单击并从上下文菜单中选择“ 导入平面文件”选项:
This will open the Import Flat File Introduction page providing an overview of the features and showing what needs to be specified in order to successfully import data from a flat file to a SQL Server database.
这将打开“ 导入平面文件 简介”页面,其中概述了功能并显示了需要指定哪些内容才能成功将数据从平面文件导入SQL Server数据库。
If you don’t wish to see this page next time the Import Flat File feature is invoked, just check the Do not show this page again. After that press the Next button to proceed with importing a flat file:
如果您不希望下次调用“导入平面文件”功能时看到此页面,只需选中“不再显示此页面” 。 之后,按“ 下一步”按钮继续导入平面文件:
The next page of the Import Flat File wizard is the Specify Input File page. On this page, we need to set up the location of a flat file which will be used for importing into a SQL Server database. Also, we need to add the name of the table which will be created into a SQL Server database to hold the imported data from a flat file:
导入平面文件向导的下一页是“ 指定输入文件”页面。 在此页面上,我们需要设置平面文件的位置,该文件将用于导入到SQL Server数据库中。 另外,我们需要添加将在SQL Server数据库中创建的表的名称,以保存从平面文件导入的数据: