Hi All,
My DB is Access.I'm trying to pull data from access database into an XML file.I'm able to pull the data.But when I try to apply WHERE clause in my sql statement,it doesn't work and is giving me the syntax error.
Here is my SQL statement,

.Source = "SELECT * FROM ([GrantNet],[Categories]) " & _
"WHERE GrantNet.Issue_Number= 01-11"

I'm not sure what mistake I'm doing.Any help is appreciated a lot.Thanks,
Fun

most likely you need single quotes around the issue number, because what your query now looks for is issue numbers equal to -10, because 01 minus 11 is -10

also, it looks like you're getting a cross join of two tables, is that what you really want?

rudy
http://r937.com/

Hi,
Thanks for the reply.But I tried putting single quotes around 'Issue_Number' .It generrates only the schema and does not generate the XML file at all.
Any suggestions??
Regards,
Fun

sorry for delay in replying, AFK for a week or so

no, put the quotes around 01-11

as for XML, sorry, can't help, wrong language