I have created a data table by querying a database and in one column the data contains both blank cells and cells populated with two digit numbers. After manipulating the data in the created data table and trying to insert it into another database table, I receive an error related to the blank cells in this single column:
Ideally, I would like to replace the blank cells with the text "Null’’ before inserting the data into the table but am not sure how to accomplish this task. Any help would be appreciated. The column is the third in the data table. I am fairly confident the error is resulting from the blank cells because the first row has a two digit number in this column and populates into the database table without issue.