RE: How to add Date records to MS ACCESS

[Maria Quinn]

On Fri, 27 Apr 2001, Sterin, Ilya wrote: 

> I believe in access you must enter date as "#02/03/1999#"
> 
> Also your query is totally wrong, it's not  
> "INSERT $date INTO table1
> VALUES($date)"
> 
> but rather 
> 
> "insert into table 1 date values ($date) 

Shouldn't that be:

insert into table1 values ($date)

I'm not familiar with Access SQL syntax, so I may be wrong.

Maria