I have several hundred records to insert into a database
My issue is
only one column is variable, that is for example
Column1 will always be the same, column2 will change, and the remain columns will also be repeated with one caveat, there is an auto generated field in the mix I need to skip.

Date |ID |Key Field | State|County|.......
Same|variable|Auto Generated| Same|Same|.............

I am not sure how to create the insert statement