How to insert data in db using jsp?

OLE DB/ODBC with EXCEL as the data source

• When using OLE DB (ODBC provider) with EXCEL as the datasource, Is there a default "table name" to the data block in the spread-sheet? Or do I always have to name a data block using Insert/Name/Define?

• Answer:

  Hi, If you do not want to provide the name for a data block using Insert/Name/Define, then the only other option that you have is to use the data in the entire worksheet. The name of the worksheet (which can be seen at the bottom, generally "Sheet1" or "Sheet2" or "Sheet3") defaults to the "table name". This table name will apply to the entire matrix starting from Row1, ColumnA to the last row/column on that worksheet that contain any data. The article (link given below) clearly explains that the only two methods of querying Excel tables via ODBC is: 1. define a range, or 2. use the worksheet name Here's the link: [http://www.rsinc.com/services/output.cfm?tip_id=3319] I knew about this topic before and hence, did not have to do any searching at all, in fact the article above was something I had bookmarked before. I hope you like the answer. Feel free to request for clarification, if needed. Regards, gopalkamat-ga