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.*