Doubt on '#' in query.

[dhwani mathur]

hi All

i am trying to get data from excel sheet
in java using jdbcodbcdrivers,but i am interested
in getting data based on particular field in Excel sheet
not all the data ,so i simply used query as below

String name=(String)jComboBox.getSelectedItem();
 
//the field to be imported will be entered by user in combobox.
 
select "+name+" from [Sheet$1]

till here it works fine.

but my code gets stuck if excel sheet has data field like

for example field :Phone# 
now if name ==(String)jComboBox.getSelectedItem();
 
//[B]now name has value Phone#[/B]
select "+name+" from [Sheet$1]

So here i am getting SQl Exception as Syntax error in date in query expression 'Phone#'.
if i change in Excel sheet Phone# to Phone then data gets imported
so i need some info onto how can i overcome this problem
of using '#' in a query if any excel sheet field has such value
because i cant keep changing excel sheet fields.


Any help on the above will be great

Thanks in advance.


Dhwani:>Winning is not important but it is the only thing.