Question: how to import data from txt to sql server?
Answer: txt file, right click and from the context menu, choose the Import Flat File option: 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.