Is there any way to read DB file in a Knime Node ? (inf.: .DB - Paradox)
Hi,
Could be a tricky one.
Try an R source node then use the packages maptools or foreign with a code like :
if (!require("maptools")) install.packages("maptools")
require("maptools")
read.dbf("C:/stock/E2D00007.DBF")
If you are under Linux you can try the Gnumeric package for R but do install the Gnumeric program first (apt-get install gnumeric)
then in the R node :
if (!require("gnumeric")) install.packages(gnumeric")
require("gnumeric")
knime.out<-read.gnumeric.sheet( "file.db",
sheet.name='Sheet3',
top.left='C3',
bottom.right='D50',
drop.empty.rows="all",
drop.empty.columns="none",
colnames.as.sheet=TRUE)
Praying for your success, spent hours on that last year.
Fabien