Welcome Guest, Not a member yet? Register   Sign In
Using mdb files on linux machine with CI
#1

[eluser]varun[/eluser]
Hi

We are using RHEL 5.0 as our production server and windows XP for development with framework CI.
Some of our databases are in MDB format which we need to process. Is there any way to process mdb files under Linux and CI environment.

(.mdb is generated at run time by some other application.)

I am completely lost. Any help is highly appreciated.
#2

[eluser]kgill[/eluser]
.mdb files are microsoft access databases - AFAIK you aren't going to get that to run under linux without purchasing some 3rd party software for ODBC. CI doesn't even enter into the picture at this point, your first hurdle is going to be trying to get at the data from linux.
#3

[eluser]renownedmedia[/eluser]
Export from access into like a CSV then import that. There are also commercial converters. But, yes, don't expect CI to talk directly to your mdb's
#4

[eluser]got 2 doodle[/eluser]
you might find something for PERL that can handle .mdb

Certainly there are libs for ODBC

The export option suggested is probably the path of least resistance :-)




Theme © iAndrew 2016 - Forum software by © MyBB