Problem in Access Query

[sijugeo]

Hi All,

I am having a table in access named 'CPP Table'. While I try to fetch data from that table using asp.net and c#, the select query it showing an error message. Well someone pointed out that the text 'Table' is creating the problem. Well anyone have any idea? How can I solve it?

Thanks,
Siju G

[nico5038]

It's a bad idea to have spaces in table names. Access will require to surround the complete name by [ and ] like:
select * from [CPP Table]

Nic;o)

[sijugeo]

Ya Thanks for your replay. Well the problem is not with the syntax. It is with the data in the table. When I tried to fetch top 10 data it worked. Thanks a lot for your time.