first you have to register the database in OOo. This is done by clicking: New >> Database >> add existing database
/* get the desktop (an Xdesktop object) */
oDesktop = UNO.createDesktop()
xComponentLoader = oDesktop~{%see com.sun.star.frame.XDesktop%XDesktop}~{%see com.sun.star.frame.XComponentLoader%XComponentLoader} --get componentLoader interface
/* open a blank calc file */
url = "private:factory/scalc"
xCalcComponent = xComponentLoader~loadComponentFromURL(url, "_blank", 0, .UNO~noProps)
/* get first sheet in spreadsheet */
xDocument = xCalcComponent~{%see com.sun.star.sheet.XSpreadsheetDocument%XSpreadSheetDocument}
xSheet = xDocument~getSheets~{%see com.sun.star.container.XIndexAccess%XIndexAccess}~getByIndex(0)~{%see com.sun.star.sheet.XSpreadsheet%XSpreadSheet}
/*set values for importing into an array*/
importDesc = bsf.createArray(.UNO~propertyValue, 3)
importDesc[1] = .UNO~propertyValue~new
importDesc[1]~Name = "DatabaseName"
importDesc[1]~Value = "rexx"
importDesc[2] = .UNO~propertyValue~new
importDesc[2]~Name = "SourceType"
importDesc[2]~Value = bsf.getConstant("{%see com.sun.star.sheet.DataImportMode}","TABLE")
importDesc[3] = .UNO~propertyValue~new
importDesc[3]~Name = "SourceObject"
importDesc[3]~Value = CD
xImport = xSheet~getCellRangeByName("A1:A1")
myImport = xImport~{%see com.sun.star.util.XImportable%XImportable} -- call interface XImportable
myImport~doImport(importDesc) -- import data
::requires UNO.CLS -- get UNO support