Thanks Guys for your help. Last night I tried using Database control to read the contents of an Excel file into JBGrid control and it worked. Jabaco Source 1 2 3 4 5 6 7 8 9 Dim myRes As ResultSet Dim myResMetaData As java#sql#ResultSetMetaData DataBase1.Connect("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\WebDemo.xls;READONLY=true}") myRes = DataBase1.ExecuteStatement("SELECT * FROM [Login$]") myResMetaData = myRes.getMetaData JBGrid1.Cols = myResMetaData.getColumnCount For intCnt ...
Hi, I want to access Excel files using Jabaco. One way is using COM object in following way (VB6): Set objExcel = CreateObject("Excel.Application") or adding reference and using Excel objects. Can this be done in Jabaco? Thanks in Advance, Unmesh