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)
I think you might want to see the SQL reference.
Ilya Sterin
-----Original Message-----
From: mi email
To: [EMAIL PROTECTED]
Sent: 04/27/2001 8:29 AM
Subject: How to add Date records to MS ACCESS
Can anyone please suggest how to enter "date" records
to an MS ACCESS db? I am running Perl/DBI/CGI, I can
INSERT any text type of data, but the script won't run
when I attempt to insert "date" type of data.
IN other words: "INSERT $date INTO table1
VALUES($date)"
Where $date is equal to 04/01/01 and I also tried
04-01-01, and other variations.
Please please help with this one.
Thanks,
MS
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
