views:

169

answers:

2

Hi all, can i import DBF files (i think it is files of paradox database) into H2 database?

I think a good solution is to write a small wrapper in java to read dbf data and save in h2 database, there is a jdbc driver to use paradox with java?

Thank you.

+1  A: 

Paradox files are not DBF. These belong to dBASE. I think Paradox files have a .DB extension. In any case, whether the files you are working with belong to Paradox or dBASE, you can easily convert the data into a format H2 can import. Your solution would work.

Randy Minder
Thank you, so there is a driver to connect to dBase database from java?ps. file *.DBF are tables of one database or are databases file?
blow
Im using paradox-dbase-reader software to read dbf data, its seems to be tables.The problems is i have a abc.DBF and abc.MDF files, and the software can't read abc.BDF file, i think the problem is this file need the file abc.MDF, isn't true?Thank again.
blow
+1  A: 

I would go for converting the .DBF files to .SQL script (with CREATEs and INSERTs). It seems to pretty much software on the Internet which could help. I haven't used any of these, so I can't suggest a particular one.

Grzegorz Oledzki