Actualy, the script we are talking about is in the article at:

http://www.sqlservercentral.com/scripts/insert/66001/

few lines after conclusion.

Does anyone noticed this logic:

Month < 8 AND month <> 2 => days_in_month = 30 + (month & 1)

Month >= 8 => days_in month = 30 + ((month+1) & 1)

Of...

Use array, as Join function helps with concatenation. Consider this macro:

Dim FieldCount As Integer

Sub makeInsert()

Dim r As Range

Dim BeginOfCommand As String

Dim RestOfCommand As String

Dim Command As String

FieldCount = 0

File =...