Member Avatar for akhilesh.nitt

hi all

The Microsoft Jet database engine has an internal limit of 255 fields per query.
but my Excel sheet containg more than this. and i have to fetch all the fields of the excel through JDBC.
plz help me how can i fetch the data ..

thanx in advance

  • 2 Contributors
  • 1 Reply
  • 55 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by masijade
Member Avatar for masijade

Try using POI (it is an apache project) or JExcel.

You won't be able to do it with the Jet engine AFAIK.

You could always break up the spreadsheet (I know, this is not an option).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.