*** 15,17 **** --- 15,20 ---- *: 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.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|