Excel and SQl Scripting

Question

I have an Excel spreadsheet with 2000 rows of data. I need to create a SQL script to insert the data into a table. Below is the formula I used in Excel and it works for creating the insert statement, but how do I "Not Insert" if DiagnosisCode already exists?

= "INSERT INTO CommonDiagnosis (DiagnosisCode, Description, ActiveThru, ActiveThruEnteredBy, DiagnosisFormat) VALUES('" & A3 & "', '" & B3 & "', '" & C3 & "', '" & D3 & "', '" & E3 & "')"

Instead of using the VALUES, use the SELECT [cell values] statement instead so you can include the WHERE DiagnosisCode NOT IN([cell value]) — Chai Xiong, Oct 04 '16 at 15:19
See this thread. http://stackoverflow.com/questions/5288283/sql-server-insert-if-not-exists-best-practice — Chai Xiong, Oct 04 '16 at 15:19

score 0 · Accepted Answer · answered Oct 04 '16 at 15:26

You could try using an IF statement:

IF NOT EXISTS
 ( SELECT DiagnosisCode 
   FROM CommonDiagnosis
 )
BEGIN
INSERT INTO CommonDiagnosis (DiagnosisCode,Description,ActiveThru,ActiveThruEnteredBy,DiagnosisFormat)
VALUES ('"&A3&"','"&B3&"','"&C3&"','"&D3&"','"&E3&"')
END;

Excel and SQl Scripting

1 Answers1