This week's book giveaway is in the Programmer Certification forum. We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
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.
We noticed he had no friends. So we gave him this tiny ad: