This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Doubt on '#' in query.

dhwani mathur
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

till here it works fine.

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

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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic