On Mar 19, 2:45 pm, John Nagle <[EMAIL PROTECTED]> wrote:
> Diez B. Roggisch wrote:
> > John Nagle schrieb:
>
> >> I'm looking for something that can read .MDB files, the format
> >> Microsoft Access uses, from Python. I need to do this on
> >> Linux, without using Microsoft tools. I just need to read
> >> the files once, so I can load the tables into another database.
> >> Speed isn't an issue, and I don't need to access the file in
> >> database fashion. The files are too big to read into RAM all at once,
> >> though.
>
> >> I tried "MDBtools", but the only (last) release was
> >> a pre-release three years ago, and I've encountered
> >> many build problems trying to make it work on Fedora
> >> Core 6.
>
> > I was just gonna suggest it. Under ubuntu, it works easy as cake, and
> > converts the mdb nicely to some CSV-files.
>
> > I think you should really try and make it work.
>
> > Diez
>
> What MDBtools did you install? The RPM, a checkout from CVS,
> or the downloadable distribution? They're all different.
>
> John Nagle
I've read .MDB files using ODBC. I don't know how big your files are,
but I had a file with almost 3000 rows and I was able to fetch it in
1-2 seconds. If you want to give it whirl, you just need to create an
ODBC connection and then do the following:
myconn = odbc.odbc('mydb_connection_name')
mycursor = myconn.cursor()
mycursor.execute('SELECT * FROM db_name')
mydata = mycursor.fetchall()
mycursor.close()
myconn.close()
for each in mydata:
# do something like pull the info from the variable "mydata" and
send it into the other database
It is fast. But you may like what the others have said more.
Mike
--
http://mail.python.org/mailman/listinfo/python-list
