Stooney Posted June 18, 2008 Share Posted June 18, 2008 I've been looking for a good program that will convert .mdb, .xls, etc into either csv or sql (or anything with some sort of delimiting so I can get it into a mysql database) without much luck. One program required I be connected to a database, most of them are limited trials I'm not willing to pay for to see if it's actually worth it, and the rest just haven't worked. So does anyone know of a (preferably free) good program compatible with vista that can convert .mdb, .xls, etc into csv or sql? Microsoft office isn't an option as that would cost way to much for a simple task. Openoffice.org is helpful but can't always read some of my .mdb files people send me. Link to comment https://forums.phpfreaks.com/topic/110825-mdb-exporter/ Share on other sites More sharing options...
tomfmason Posted June 18, 2008 Share Posted June 18, 2008 check out http://mdbtools.sourceforge.net/ Link to comment https://forums.phpfreaks.com/topic/110825-mdb-exporter/#findComment-568602 Share on other sites More sharing options...
Stooney Posted June 18, 2008 Author Share Posted June 18, 2008 That's on the right track but unfortunately it seems to be linux only. I need a windows compatible program. Link to comment https://forums.phpfreaks.com/topic/110825-mdb-exporter/#findComment-568625 Share on other sites More sharing options...
Stooney Posted June 19, 2008 Author Share Posted June 19, 2008 Also another question. I just installed the office enterpise 2007 trial. Now when I open this database (.mdb access 97 format) it opens it and says there were errors and whatnot, but I am still able to export the first table from it. I only need to export 1 table, but it's not the 'default' selected one. My problem is that I dont get the menu on the right listing the tables so I have no way of selecting which table I wish to export to csv. I can't even find a way to export the entire database. So if anyone out there familiar with access 2007 knows a way around this that would help a ton. Link to comment https://forums.phpfreaks.com/topic/110825-mdb-exporter/#findComment-568632 Share on other sites More sharing options...
tomfmason Posted June 19, 2008 Share Posted June 19, 2008 I don't really use windows unless I have to. So, I am not sure what applications are available to you. Link to comment https://forums.phpfreaks.com/topic/110825-mdb-exporter/#findComment-568667 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.