MS Data control

[badgers]

I am using the control that has a tool tip "Data"
I am trying to get information from a table.
the table name is "Job List" this name has a space in it.there are fields that have spaces in there names as well.
It is giving me problems. is the space causeing problems? how do I get around this. I can NOT change the database table name or field names.
thank you for your time and have a good day

------------------
I am so skeptacle, I can hardly believe it!

[kishore]

No doubt Space is causing problems.
I think of only one thing without changing the database.Using Square brackets[ ]

Use the table names in Square brackets
eg:
Select * from [job List]

You should do the same with the field names too. It cannot recognize whether it is a keyword or tablename or variable name.

If it doesn't work, then there is no possible way except to change the database.


Good luck,
krishna

[badgers]

you da man!!!! :

------------------
I am so skeptacle, I can hardly believe it!