Import into an existing table with bulk insert SQL Server 2008

Question

I already have an existing table with millions of rows. An external text file (with tab delimiters) should be able to use an existing table. After both datasets are in the same table, I normalize. My existing table has the same table structure as the one I import. If I do something like

BULK INSERT TableName FROM 'C:\SomeDirectory\my table.txt' WITH ( FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n' ) GO 

Will it add or replace existing data?

Answer 1

He adds. If you want to replace TRUNCATE or DELETE first.