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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com