Question: how to import text file data into sql server table?
Answer: Open SQL Server Management Studio.
Connect to an instance of the SQL Server Database Engine or localhost.
Expand Databases, right-click a database (test in the example below), point to Tasks, and click Import Flat File above Import Data.