opening xls files in kbasic

ashwinkumar · 01-24-2009, 10:26 PM

hi

is it possible to access the xls files like databases in kbasic??

i mean is there something like recordset to access xls datas record by record???

if so show me a way..

thanks in advance

paulsm4 · 01-25-2009, 12:20 AM

.Xls files are Microsoft Excel files.

"Recordsets", as you're familiar with, are Microsoft ADO ActiveX objects.

Accessing MS Excel in MS Visual Basic on MS Windows ... sure (provided you have MS Office installed, of course ;-))

Accessing MS Excel, or doing COM/ActiveX, on Linux with KBasic ... good luck!

PS:
There's always OpenOffice and ODF format, which is completely open and completely portable to any platform/language you can imagine:

http://en.wikipedia.org/wiki/OpenOffice.org_Calc