why the insert stmt doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
My insert statement doesn't work with the where clause in Access 2003. it
works fine if I remove the where clause. Can somebody please explain the
problem. thanks
Kanan
cn.Execute "INSERT INTO temp_Data SELECT master_Data.* FROM Master_Data
WHERE master_Data.CourseTitle Like '*mutipli*patterns*';"
 
Kanan said:
Hi,
My insert statement doesn't work with the where clause in Access
2003. it works fine if I remove the where clause. Can somebody
please explain the problem. thanks
Kanan
cn.Execute "INSERT INTO temp_Data SELECT master_Data.* FROM
Master_Data WHERE master_Data.CourseTitle Like
'*mutipli*patterns*';"
Click to expand...

If you're using ADO, the wildcard is % not *
 
It looks like 'mutipli" is misspelled.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieve value after insert 3
Access + Insert Into + confirmation dialog 2
Insert row, table to table - where append goes to correct record 2
Insert Into Query 5
Insert Into Query 1
CurrentDb.OpenRecordset & "Too Few Parameters expected 1". 6
Record insert/delete anomaly 0
SQL code doesn't work in a VBA module 3

Back
Top