Hi All,
I have the following query in vb application:
Else
SQL = "Insert Into GRSEXPORT([Product Number (SKU)],[Serial Numbers],[Sell Through Quantity],[Programe ID],"
SQL = SQL & "[Company Name],[Transaction Doc ID],[Partner Locn ID],[Transaction Date]"
SQL = SQL & ") Values('" & rs.Fields("Product Number (SKU)") & "','"
SQL = SQL & rs.Fields("Serial Numbers") & "','" & rs.Fields("Sell Through Quantity") & "','"
SQL = SQL & rs.Fields("Programe ID") & "','" & Replace(rs.Fields("Seller - Company Name") & "", "'", "''") & "','"
SQL = SQL & rs.Fields("Trans Doc ID") & "','" & rs.Fields("Partner Locn ID") & "" & "',#"
SQL = SQL & rs.Fields("Trans Date") & "#)"
Cnn.Execute (SQL)
End If
Here, all the data are being inserted in a single row in the table. But I want only the null values in one row and non-null values in another row..
Can any one please suggest me how do I do this?
Regards,