COMPETES import scripts

[clizbe]

Tasks

• Imported to SQLite
• Recipe to attach SQLite db to DuckDB
  • Optionally, if necessary, may convert to native DuckDB
• Scripts to convert tables to what Tulipa expects

Export MS Access db to SQlite

This works on Linux (so also works on Windows WSL):

1. Install mdbtools & sqlite-tools (optional)
2. Then in the shell (bash)

   mdb-schema /path/to/ms-access.mdb > schema.sql
   sqlite3 /path/to/sqlite-copy.db < schema.sql
   for tbl in $(IFS=$'\n' mdb-tables -1 /path/to/ms-access.mdb); do
     {
         mdb-export /path/to/ms-access.mdb "$tbl" | \
           sqlite-utils insert -c /path/to/sqlite-copy.db "$tbl" - ;
     } && echo "'$tbl' exported";
   done

Reading from DuckDB

See SQLite import

INSTALL sqlite;
ATTACH 'sqlite-copy.db' AS competes (TYPE sqlite);
USE competes;
SHOW TABLES;