On Thu, 12 Nov 2009, Alex Mandel wrote:
> Using R might actually be a convenient way to do it all in essentially
> one step, and technically batch scriptable.
I found a perl script that converts .dbf to .csv. It's then trivial to
import the .csv into SQLite.
Rich
_
Using R might actually be a convenient way to do it all in essentially
one step, and technically batch scriptable.
You'd need the RSQlite add on package, I think dbf reading is built in.
Alex
dave lilley wrote:
> 2009/11/12 Rich Shepard
>
>> On Thu, 12 Nov 2009, dave lilley wrote:
>>
>>> Not t
Hello!
On Thursday 12 November 2009 07:30:28 Rich Shepard wrote:
>Perhaps. I learned today that only the Winduhs version of OO.o can import
> .mdb files; the linux version cannot.
Try to read by Linux ODBC and save to SQLite.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
2009/11/12 Rich Shepard
> On Thu, 12 Nov 2009, dave lilley wrote:
>
> > Not trying to be silly here but why not write a wee program that reads in
> > the dbf file and for each row read in write the data into an sql file?
>
> Because I'd have to research the format of the .dbf file and I'd proba
On Thu, 12 Nov 2009, Jean-Christophe Deschamps wrote:
> I'm pretty sure OpenOffice can do a number of such conversions, free and
> portable. About command-line tools for linux, I just don't know.
Perhaps. I learned today that only the Winduhs version of OO.o can import
.mdb files; the linux v
On Thu, 12 Nov 2009, dave lilley wrote:
> Not trying to be silly here but why not write a wee program that reads in
> the dbf file and for each row read in write the data into an sql file?
Because I'd have to research the format of the .dbf file and I'd probably
be re-inventing the wheel.
Ric
Reid Thompson wrote:
> Jean-Christophe Deschamps wrote:
>>>Now that I have a working tool to convert from Access .mdb to sqlitedb
>>> files, I need one for dBASE .dbf files. Or, a conversion to .csv will
>>> work,
>>> too. Needs to run on linux, of course.
>
> perhaps
> http://developer.berli
Jean-Christophe Deschamps wrote:
>
>>Now that I have a working tool to convert from Access .mdb to sqlitedb
>> files, I need one for dBASE .dbf files. Or, a conversion to .csv will
>> work,
>> too. Needs to run on linux, of course.
perhaps
http://developer.berlios.de/projects/dbf/
__
>Now that I have a working tool to convert from Access .mdb to sqlitedb
>files, I need one for dBASE .dbf files. Or, a conversion to .csv will
>work,
>too. Needs to run on linux, of course.
>
>My Google searches turned up a bunch of tools for the Windows
> platforms,
>supposedly free co
Not trying to be silly here but why not write a wee program that reads in
the dbf file and for each row read in write the data into an sql file?
note the sql database & tables would be already created.
in this message you don't really give an indication on whether you are able
to do this or not s
Now that I have a working tool to convert from Access .mdb to sqlitedb
files, I need one for dBASE .dbf files. Or, a conversion to .csv will work,
too. Needs to run on linux, of course.
My Google searches turned up a bunch of tools for the Windows platforms,
supposedly free converters that h
11 matches
Mail list logo
