I have the following dataframe:

```
data = [['Alex', 182.2],['Bob', 183.2],['Clarke', 188.4], ['Kelly', NA]]
df = pd.DataFrame(data, columns = ['Name', 'Height'])

```

I have the following SQL Server table:

```
create table dbo.heights as (
   name    varchar(10),
   height  float 
)

```

This is my code to upload the data to my table:

```
for index,row in df.iterrows():
    cursor.execute('INSERT INTO dbo.heights(name, height) values (?, ?)', row.name, row.height)
    cnxn.commit()
cursor.close()
cnxn.close()

```

I want to upload the dataframe into my SQL Server table, but it fails on the null value. I tried replacing the NA with an `np.nan` value and it still failed. I also tried changing the height column to an "object" and replacing the NA with None and that also failed.