Page History
- 2024-Jan-10 12:44 anonymous
- 2023-Jun-15 13:48 anonymous
- 2021-Jun-24 09:02 anonymous
- 2019-Dec-21 05:14 anonymous
- 2017-Aug-08 09:12 anonymous
- 2017-Aug-08 09:10 anonymous
- 2015-Aug-02 15:17 anonymous
- 2015-Aug-02 15:16 anonymous
- 2015-Aug-02 15:15 anonymous
- 2008-Jan-18 11:09 anonymous
- 2007-Dec-09 18:27 anonymous
- 2007-Dec-09 18:25 anonymous
- 2007-Mar-22 10:36 anonymous
- 2006-Dec-02 22:54 anonymous
- 2006-Nov-02 16:02 anonymous
- 2006-Sep-21 09:06 anonymous
- 2006-Aug-30 01:22 anonymous
- 2006-Aug-08 21:08 anonymous
- 2006-Aug-07 20:44 anonymous
- 2006-Jul-07 01:56 anonymous
- 2006-Jun-29 18:02 anonymous
- 2006-Jun-28 19:13 anonymous
- 2006-May-10 09:03 anonymous
- 2006-Apr-04 16:55 anonymous
- 2005-Dec-02 02:49 anonymous
- 2005-Oct-31 23:26 anonymous
- 2005-Oct-11 00:22 anonymous
- 2005-Sep-20 21:24 anonymous
- 2005-Aug-10 00:00 anonymous
- 2005-Aug-09 23:58 anonymous
- 2004-Oct-05 12:43 anonymous
- 2004-Oct-05 12:43 anonymous
- 2004-Jul-04 12:40 anonymous
- 2004-May-13 08:58 anonymous
- 2004-May-06 09:41 anonymous
- 2004-Feb-16 08:40 anonymous
- 2004-Feb-16 08:28 anonymous
- 2003-Dec-01 13:05 anonymous
- 2003-Nov-20 11:23 anonymous
- 2003-Nov-20 11:21 anonymous
- 2003-Nov-05 13:19 anonymous
- 2003-Oct-23 22:24 anonymous
- 2003-Oct-23 22:10 anonymous
- 2003-Oct-23 22:08 anonymous
- 2003-Aug-07 09:02 anonymous
- MDB Tools
The MDB Tools project is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms.
Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others.
Also, included is a SQL engine for performing simple SQL queries. The 0.5 release includes an updated GUI interface (screenshot is available here). A sparse but functional ODBC driver is included as well.
MDB Tools currently has read-only support for Access 97 (Jet 3) and Access 2000/2002 (Jet 4) formats. Access 2000 support is a recent addition and may not be as complete as Jet 3 support.
Write support is currently being worked on and the first cut is expected to be included in the 0.6 release.
Note: I don't think it supports SQLite right now, but this project can be continued and used for that purpose.
- Simple VB MDB to SQLite
I coded up a small limited visual basic tool that takes in an MDB and produces a text file that can be piped into the sqlite command line tool to create a database. It's simple and very dirty code, but it does work for simple databases. It's attached to this document and you can do whatever you want with it.
i did a few improvements to vb mdbtosqlite to convert northwind, orders, biblio, and gallery ms-access sample mdbs to sql code loadable in sqlite. everything was read fine, with the exception of binary picture fields, which are also been reported in the output file, as comments closely following each create table statement. the ofending fields are still being created with "BINARY" type and inserted as NULL. code is posted as mdbtosqlite2.zip, so that the original author might examine it and hopefully merge the two versions.
<rapto@arrakis.es> I have modified this program into a vbs so you don't have to have Visual Basic.
Attachments:
- fx2lite.prg 5579 bytes added by anonymous on 2006-Sep-21 09:03:53 UTC.
- A DOS foxpro program to transfer .dbf into an sqlite table is here
- MDBtoSQLite.vbs 16259 bytes added by anonymous on 2008-Jan-18 11:07:20 UTC.
Takes in an MDB and produces a text file that can be piped into the sqlite command line tool to create a database. 2008-01-16 <lokkju@lokkju.com> Fixed INTEGER field types to handle null data, now will insert 0, used to break it by inserting nothing. Also modified to accept database path from the command line as an argument.