SitePoint Sponsor

User Tag List

Results 1 to 16 of 16
  1. #1
    SitePoint Member
    Join Date
    Oct 2006
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mdb file to mysql

    Hi all,

    I have a large mdb file, which I want to upload to the server (linux) and store the data from it to my MySql database using a PHP program. As Linux server does not support Access files, how can I make it possible ? How can I convert mdb file to csv using PHP ? Please help me.

    Thanks in advance.

  2. #2
    SitePoint Evangelist ikeo's Avatar
    Join Date
    Oct 2004
    Location
    Austin Texas
    Posts
    591
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can't you just export the data to csv from Microsoft Access?

    Quote Originally Posted by renjithv View Post
    Hi all,

    I have a large mdb file, which I want to upload to the server (linux) and store the data from it to my MySql database using a PHP program. As Linux server does not support Access files, how can I make it possible ? How can I convert mdb file to csv using PHP ? Please help me.

    Thanks in advance.

  3. #3
    SitePoint Member
    Join Date
    Oct 2006
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No it is not possible because I am using Linux server. I need to convert it using PHP code.

    Thanks

  4. #4
    Ž.Ž shoooo... silver trophy logic_earth's Avatar
    Join Date
    Oct 2005
    Location
    CA
    Posts
    9,013
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    I think he means from your desktop convert it to CSV from MS Access. Seriously there are easier ways to do things then try and make some program in PHP when the original application can do it already.
    Logic without the fatal effects.
    All code snippets are licensed under WTFPL.


  5. #5
    SitePoint Member
    Join Date
    Oct 2006
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply. ..But I need to convert it from the server itself.

    Thanks

  6. #6
    SitePoint Addict
    Join Date
    Nov 2002
    Location
    Maryland
    Posts
    307
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I used this program and it worked great for me.

    http://www.mdbtomysql.de/

  7. #7
    SitePoint Member
    Join Date
    Oct 2006
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I need a php file which can be used in Linux (working in Linux platform). I need to read mdb file and store the data to MySql.

    Thanks

  8. #8
    SitePoint Addict aniltc's Avatar
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    399
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    can you give us some more details?
    i am not getting why you want to store mdb files in server.do onething convert mdb files to mysql using 'JeffGSR' method and write a mysql query using php.so the problem solved

  9. #9
    SitePoint Member
    Join Date
    Jul 2007
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face

    Hi !
    I am Brazilian.
    Excuse me, I don't speak english. But I need help.

    "I need a php file which can be used in Linux (working in Linux platform). I need to read mdb file and store the data to MySql" too.

    I use linux server and I can't to use program out web for read the mdb file.

    You understand??

    Thank you so much.

    Dammybr

  10. #10
    SitePoint Evangelist
    Join Date
    Jan 2006
    Location
    UK
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  11. #11
    SitePoint Evangelist
    Join Date
    Aug 2005
    Posts
    453
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK, download the ADODB.
    Documentation @ http://phplens.com/lens/adodb/docs-adodb.htm

    The ADODB package has drivers available for .mdb files. I presume you can back this .mdb file up from your linux server. Ftp your database back up file to your server, then open using the ADODB package. Read a line and write it to your MySQL database. If you need a ready to run solution post your database table layout to this thread and someone will cut you the working code.
    Computers and Fire ...
    In the hands of the inexperienced or uneducated,
    the results can be disastrous.
    While the professional can tame, master even conquer.

  12. #12
    SitePoint Member
    Join Date
    Jul 2007
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for help me.

    http://bryanmills.net:8086/archives/...linux-and-php/ donīt open.

    But, I need read .mdb file in the server, in the web.
    I donīt have the access database in the server.
    I only have the .mdb file and I canīt to modify it before the sending.
    I can't use softwares in the machine, I think in to use PHP script, but I don't know I eat to develop it.

    This process of reading will have every day to be executed automatically in the server for to bring up to date MySQL db.

  13. #13
    SitePoint Member
    Join Date
    Jul 2007
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Help me, please....

  14. #14
    Ž.Ž shoooo... silver trophy logic_earth's Avatar
    Join Date
    Oct 2005
    Location
    CA
    Posts
    9,013
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    You cannot do anything since you are reluctant to follow the instructions people are giving you.

    Talk to your host about installing the software you need the hire a developer that knows what he/she is doing.

    Or stop using MS Access have it export a CSV or something not an MS file format.
    Logic without the fatal effects.
    All code snippets are licensed under WTFPL.


  15. #15
    SitePoint Member
    Join Date
    Jul 2007
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks

  16. #16
    SitePoint Evangelist
    Join Date
    Jan 2006
    Location
    UK
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by dammybr View Post
    Thanks for help me.
    http://bryanmills.net:8086/archives/...linux-and-php/ don´t open.
    Code:
    http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-linux-and-php/
    I just tried it again and it worked fine. The article there tells you all you need to know.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •