syntax error in insert into statement. in the insert values in ms access database.

Question

0.00/5 (No votes)

See more:

Insert into Tb_Faculty_Availability format (Available_date,'dd/mm'/yyyy) values ('AKR','18/3/2013');

when i run the above query in ms access shows the error as follows.

syntax error in insert into statement.

what is the mistake i made in my above query.

please help me.

Regards,
Narasiman P.

Posted 7-Mar-13 3:13am

Member 8054539

Add a Solution

Comments

[no name] 7-Mar-13 9:18am

Maybe you should just break down and do what the answerer's to your other questions have told you to do and use parametrized queries. That would save you from having to come here every ten minutes to post (spamming) yet another "syntax error in your query" question. Just a thought.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-03-07T03:18:00

Solution 1

Try with this syntax:

SQL

INSERT INTO YourTable (CharField1, DateField1)
VALUES ('Some Text', #2013-03-07#)

Posted 7-Mar-13 3:18am

Maciej Los

syntax error in insert into statement. in the insert values in ms access database.

1 solution

Solution 1

Add your solution here

Preview 0

syntax error in insert into statement. in the insert values in ms access database.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us