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)
 
Back
Top