@rmcvicar technically Zapier doesn’t support this as a good use case for their system, essentially parsing CSV files. However, many of us do this all the time. There is a hack/trick that needs to happen, but once that is in place the rest is simple. 

The hack basically is a code step that receives the URL (publically accessible) of a CSV and then breaks it into line items (Zapier’s terminology for row by row processing) And then the rest of the zap runs for each row. (so you can add it to a SQL database. )

The key is in the python code step. here’s a screenshot of how I do this using Code by Zapier > Python

The specific code block is: 

import csv
with requests.Session() as s:
    download = s.get(input_data('fileurl'])
    decoded_content = download.content.decode('utf-8')
    cr = csv.DictReader(decoded_content.splitlines(), delimiter=',')
return {"Rows": list(cr)}

This will return a key of “Rows” where the first line item in Rows is the first row of the spreadsheet. here’s an example output:

So using that step in a zap for you I would do the following:

Step 1: Trigger: Schedule by Zapier, Daily at 7:15am

Step 2: Code by Zapier > Python -- copy the code from above, use the URL of the HCOInv.csv file

Step 3. SQL Server > New Row use the output of step 2 to populate the row values in your database

Let me know if that works for you.