Ive been working on this script that does 2 things. 1 it creates a table, and the 2nd part imports a csv file into that table.

Code:
BULK INSERT PHCR_YEARM+D!
    FROM 'C:\Import\ClaimReceived\PHCR_YEARM+D!.csv'
    WITH 
    ( 
        FIRSTROW = 2, 
        FIELDTERMINATOR = ',',
        ROWTERMINATOR = '\n'
    )
Using notepad i just replace YEAR with the...