Inserting SQL NULL values via SQL Bulk Insert

unknown

Hi,

does anyone know how to insert SQL NULL values using SQLBulkInsertData() ?

I'm creating a in mermory table using SQLCreateInMemoryTable(), then adding some level columns using SQLDataAddColumn() - datatype string.

For the "SQL row data" I create a VariantList and then append the data to it. But I can't append null to the VariantList. When I try to append "NULL" (as string), the cells in SQL are filled with the string NULL

Best Regards

Pascal

ivan-rebo

CreateNullVariant()

0911060553270289.pdf