Hi Frank, Am Freitag, den 04.01.2008, 21:32 +0100 schrieb Frank Schönheit - Sun Microsystems Germany: > Hi Marc, > > > Sub Main > > Dim oDestDesc as Object > > oDestDesc = createDataAccessDescriptor() > > oDestDesc.DataSourceName = "Spielwiese" > > ' oSourceDesc.ConnectionResource = > > "sdbc:dbase:file://g:/office/dba24d/user/database/biblio" > > oDestDesc.CommandType = com.sun.star.sdb.CommandType.TABLE > > oDestDesc.Command = "Masse" > > > > Dim oSourceDesc as Object > > oSourceDesc = createDataAccessDescriptor() > > oSourceDesc.DatabaseLocation = > > "file:///e:/Daten/Dokumente/OOo_DB/Massendaten/datagen7.txt" > > DatabaseLocation has to be the URL of an .odb file. If you want to > specify the text file as source, use ConnectionResource and "sdbc:file:...".
That was a good laugh, when I saw the "biblio"-thingy right before my eyes after you mentioned it. :D But after all I'couldn't make it run that easy: ... Dim oSourceDesc as Object oSourceDesc = createDataAccessDescriptor() oSourceDesc.ConnectionResource = "sdbc:file:file:///e:/Daten/Dokumente/OOo_DB/Massendaten/"'datagen7.csv" oSourceDesc.CommandType = com.sun.star.sdb.CommandType.TABLE 'oSourceDesc.Command = "datagen7" oSourceDesc.Command = "datagen7.csv" ... I tried that way iterating over some variants and got an uno.RuntimeException saying: "invalid attempt to assign an empty interface of type css.sdbc.XConnection!" Still something missing? TIA, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
