Blank date in SQL construct using VBA 1

[LARiot]

How do I insert a blank date into a table?

The result of my constructed SQL statement in VBA is:

INSERT INTO tblActiveDeal VALUES ('C:\Documents and Settings\nsepassi\My Documents\Revenue Project\Excel Sheets\Active Deals Report - Apr 07 from Danny.xls', 'E_$', 'SG', '420.000', 'Alpha Satellite Television S.A.', ##, #12:00:00 AM#, 0, '', , , , 4, 0, 'Count Newsfeed as 1 hour, not 90 minutes.' )

Thanks.

 

[PWise]

[CODE vba]
INSERT INTO tblActiveDeal VALUES ('C:\Documents and Settings\nsepassi\My Documents\Revenue Project\Excel Sheets\Active Deals Report - Apr 07 from Danny.xls', 'E_$', 'SG', '420.000', 'Alpha Satellite Television S.A.', null , #12:00:00 AM#, 0, '', , , , 4, 0, 'Count Newsfeed as 1 hour, not 90 minutes.' )[/code]

 

[PHV]

Replace this:
##
with this:
Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886