-----Original Message-----
From: Bodo Eing
To: Maria Quinn
Cc: 'mi email '; '[EMAIL PROTECTED] '
Sent: 04/27/2001 9:03 AM
Subject: RE: How to add Date records to MS ACCESS
Date sent: Fri, 27 Apr 2001 15:55:21 +0100 (BST)
From: Maria Quinn <[EMAIL PROTECTED]>
To: "Sterin, Ilya" <[EMAIL PROTECTED]>
Copies to: "'mi email '" <[EMAIL PROTECTED]>,
"'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
Subject: RE: How to add Date records to MS ACCESS
> 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
"insert into table1 date values ($date)"
>is probably closest to what was meant by mi email. Ilya's version
>contained just a typo (the space between 'table' and '1'). BTW, what
>about storing your dates as long integers and leaving the conversion
>from input and to formatted output to the application level ?
Wooppss, typing too fast, sorry.
>Bodo
>[EMAIL PROTECTED]
>Dr. med. Bodo Eing
>Institut fuer Medizinische Mikrobiologie
>Klinische Virologie
>v.-Stauffenbergstr. 36
>48151 Muenster
>Germany
Phone: ++49 251 7793 111 Fax: ++49 251 7793-104
