Gord Thompson

Just for fun I tried using UCanAccess (which uses Jackcess as its record manager), JayDeBeApi, and pandas to dump a table with 1_000_000 rows (96 MiB .accdb file) to SQLite using Python. The process took 131 seconds (just over 2 minutes) on a very old and slow machine: import sqlite3 from time import perf_counter import jaydebeapi import pandas as pd db_path = "/home/gord/Documents/MillionRows.accdb" ucanaccess_jars = [ "/home/gord/Downloads/UCanAccess-5.0.1.bin/ucanaccess-5.0.1.jar", "/home/gord/Downloads/UCanAccess-5.0.1.bin/lib/commons-lang3-3.8.1.jar",...

Just for fun I tried using UCanAccess (which uses Jackcess as its record manager), JayDeBeApi, and pandas to dump a table with 1_000_000 rows (96 MiB .accdb file) to SQLite using Python. The process took 131 seconds (just over 2 minutes): import sqlite3 from time import perf_counter import jaydebeapi import pandas as pd db_path = "/home/gord/Documents/MillionRows.accdb" ucanaccess_jars = [ "/home/gord/Downloads/UCanAccess-5.0.1.bin/ucanaccess-5.0.1.jar", "/home/gord/Downloads/UCanAccess-5.0.1.bin/lib/commons-lang3-3.8.1.jar",...

Try creating a table with a "Large Number" column. That may trigger the schema upgrade.

and, at least according to the change log UCanAccess calls those columns BIGINT.

Home

I can reproduce the issue with the attached .accdb file. PS C:\Users\Public\Downloads\UCanAccess> ./console.bat java version "1.8.0_241" Java(TM) SE Runtime Environment (build 1.8.0_241-b07) Java HotSpot(TM) 64-Bit Server VM (build 25.241-b07, mixed mode) Please, enter the full path to the access file (.mdb or .accdb): C:\Users\Gord\Desktop\infinity.accdb Loaded Tables: Loaded Queries: Loaded Procedures: Loaded Indexes: Primary Key on Table1 Columns: (ID) net.ucanaccess.jdbc.UcanaccessSQLException:...

I can reproduce the issue with the attached .accdb file. PS C:\Users\Public\Downloads\UCanAccess> ./console.bat java version "1.8.0_241" Java(TM) SE Runtime Environment (build 1.8.0_241-b07) Java HotSpot(TM) 64-Bit Server VM (build 25.241-b07, mixed mode) Please, enter the full path to the access file (.mdb or .accdb): C:\Users\Gord\Desktop\infinity.accdb Loaded Tables: Loaded Queries: Loaded Procedures: Loaded Indexes: Primary Key on Table1 Columns: (ID) net.ucanaccess.jdbc.UcanaccessSQLException:...

Try running the console.bat or console.sh command-line utility, specify the .accdb file when prompted, and see if ERZEUGNISSE_KOMPONENTEN appears in the list of tables (or views) that are loaded.