Results 1 to 4 of 4

Thread: How to get data from .mdb database?

  1. #1
    Join Date
    Jan 2006
    Location
    Kranj, Slovenia
    Posts
    34
    Thanks
    5
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default How to get data from .mdb database?

    Where can I get driver for Access database? Is there something else than ODBC?

    TNX!

    Luka

  2. #2
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,363
    Thanks
    3
    Thanked 5,012 Times in 4,791 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: How to get data from .mdb database?

    No. ODBC only. Unless you convert your access dbase to something more edible...

  3. #3
    Join Date
    Jan 2006
    Location
    Kranj, Slovenia
    Posts
    34
    Thanks
    5
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: How to get data from .mdb database?

    TNX for confirming my fears...
    I have found SQLite Analyser (evaluation for 30 days, but is good for a quick solution). There are several others open source, but none of them converted my databases like I want to.

    Tnx again!
    Luka

  4. #4
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,363
    Thanks
    3
    Thanked 5,012 Times in 4,791 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: How to get data from .mdb database?

    The easiest way to do the conversion would be to write some kind of script in Access which will transform the contents of the database into a set of INSERT statements which you can then execute from within some normal dbms to fill it with your data (remember to generate the CREATE TABLE entries too).

Similar Threads

  1. Problem while inserting the data into database
    By sudheer168 in forum Qt Programming
    Replies: 2
    Last Post: 13th December 2008, 12:22
  2. Replies: 2
    Last Post: 8th August 2008, 01:54
  3. Replies: 15
    Last Post: 27th May 2008, 01:46
  4. Replies: 5
    Last Post: 8th April 2008, 23:10
  5. Multiple database connections
    By cyberboy in forum Qt Programming
    Replies: 3
    Last Post: 30th March 2008, 16:56

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
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.