How to add date in access database

's Computer Specifications

I am trying this:
SQL = "INSERT INTO GradeList (Date) Values(#01-01-2007#)"

I get message "Syntax error in Insert statement".

How to add date field in access database?

's Computer Specifications

By enclosing Date in square brackets or renaming the column not using a
reserved word.

SQL = "INSERT INTO GradeList ([Date]) Values(#01-01-2007#)"

SQL = "INSERT INTO GradeList (the_Date) Values(#01-01-2007#)"

Bob Lehmann

"Tony" <(E-Mail Removed)> wrote in message
news:es1avr$qor$(E-Mail Removed)...
> I am trying this:
> SQL = "INSERT INTO GradeList (Date) Values(#01-01-2007#)"
>
> I get message "Syntax error in Insert statement".
>
> How to add date field in access database?
>
>
>
>

's Computer Specifications

On Tue, 27 Feb 2007 14:30:50 +0100, "Tony" <(E-Mail Removed)> wrote:

¤ I am trying this:
¤ SQL = "INSERT INTO GradeList (Date) Values(#01-01-2007#)"
¤
¤ I get message "Syntax error in Insert statement".
¤
¤ How to add date field in access database?

The keyword Date is reserved (it's a function). Use a different name for your column.

Paul
~~~~
Microsoft MVP (Visual Basic)

's Computer Specifications

Hi,

First of all there is no need to post to so many groups at the same time.

Regarding your problem, Date is a reserved word, you have to refer to it as
[Date]
Additionally I would suggest you to use parametered queries.

"Tony" <(E-Mail Removed)> wrote in message
news:es1avr$qor$(E-Mail Removed)...
>I am trying this:
> SQL = "INSERT INTO GradeList (Date) Values(#01-01-2007#)"
>
> I get message "Syntax error in Insert statement".
>
> How to add date field in access database?
>
>
>
>

's Computer Specifications

Ignacio

I suggest you take your C# _CRAP_ and shove it up your ass.

If I want to get your advice, I'll call the cSharp FAGS i promise

your langauge doesn't EXIST

On Feb 27, 2:29 pm, "Ignacio Machin $ .NET/ C# MVP $" <machin TA
laceupsolutions.com> wrote:
> Hi,
>
> First of all there is no need to post to so many groups at the same time.
>
> Regarding your problem, Date is a reserved word, you have to refer to it as
> [Date]
> Additionally I would suggest you to use parametered queries.
>
> "Tony" <tonya...@hotmail.com> wrote in message
>
> news:es1avr$qor$(E-Mail Removed)...
>
> >I am trying this:
> > SQL = "INSERT INTO GradeList (Date) Values(#01-01-2007#)"
>
> > I get message "Syntax error in Insert statement".
>
> > How to add date field in access database?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to add date in access database	Tony	Microsoft ADO .NET	5	27th Feb 2007 10:58 PM
How to add date in access database	Tony	Microsoft VB .NET	4	27th Feb 2007 10:58 PM
How to add date in access database	Tony	Microsoft ASP .NET	4	27th Feb 2007 10:58 PM
Export Outlook date field as date/time format to Access database	=?Utf-8?B?QmVja3k=?=	Microsoft Outlook Discussion	0	2nd Dec 2004 02:49 PM
date columns in access database	Mr. x	Microsoft Access	3	13th Nov 2003 05:55 PM