You are not logged in.

Search results

Search results 1-2 of 2.

Wednesday, February 4th 2009, 6:11am

Author: upgundecha

Accessing Excel Files

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 ...

Tuesday, February 3rd 2009, 1:34pm

Author: upgundecha

Accessing Excel Files

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

WoltLab Burning Board