Import CSV (flat file) using SQL Server Management Studio in existing table

Question

May someone please let me know if there is a way to import CSV files in an existing table using SQL Server Management Studio GUI

I tried the below but this method always creates a new table and will not allow importing in an existing table:

Right click the database and select Tasks -> Flat File...
Click the Next > button.
For Data Source, select Flat File Source. Then use the Browse button to select the CSV file. Spend some time configuring the data import before clicking the Next > button.

Answer 1

For Microsoft SQL Server Management Studio (SSMS) 19.1

• Connect to server
• Select database (not table)
• Right click on database
• Select Tasks -> Import Data...*
• Select Flat File Source

*Do not select Import Flat File... directly. This launches new verion of Import Wizard which does not allow import into already existing table.