4

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.*
M-A Charlotte
  • 325
  • 1
  • 3
  • 10
  • Right Click Database -> Tasks -> Import Data. Follow instructions in the wizard; ensure you select your existing table when you get to the relevant screen (which you clearly were not). – Thom A Oct 05 '21 at 14:44
  • 1
    on the "select source tables and views" window in the right hand side under destination click on the "new" table name and a down arrow should appear that will show you exg tables to select – GrahamH Oct 05 '21 at 14:47
  • 4
    You know Sql Server 2008 is end of life right? It no longer gets any updates... **not even critical security patches**, of which there are now several. It's dangerous and irresponsible to still be using this. – Joel Coehoorn Oct 05 '21 at 14:54

1 Answers1

0

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.

herdek550
  • 625
  • 1
  • 5
  • 10