Urgent,how assign null value to a field in access

[Guest_imported]

vb6
access 97

how can assign a null value to any field to any table from vb6 to access database

please,

 

[sunaj]

Hi,

If you don't insert any value it will be null, so there seems to be little point in doing it. But it can be done:

con.Execute "INSERT INTO TblMyTable(name) VALUES (NULL)"

Sunaj

 

[sunaj]

Hi,

That comment was not quite thought throug - well its still early in the morning. It probably more relavant in a UPDATE statment:

con.Execute("UPDATE TblMyTable SET name = NULL WHERE name='sunaj'&quot

X-)Sunaj