Declare @JSON varchar(max)
SELECT @JSON=BulkColumn
FROM OPENROWSET (BULK 'C:\TMP\zipcodes.json', SINGLE_CLOB) import

insert into  [dbo].[Zipcodes](
    Zip
)
SELECT *
FROM OPENJSON (@JSON)
with(
    [value] VARCHAR(5) '$'
)