Recent

« previous next »
Pages: [1]

Author Topic: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?  (Read 1090 times)

Weitentaaal

  • Full Member
  • ***
  • Posts: 113
Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
« on: January 19, 2021, 09:17:36 am »
Thanks :D
Logged
Lazarus: 2.0.6 x86_64-win64-win32/win64
FPC-Version: 3.0.4
Compiler Version: 3.2.0

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
« Reply #1 on: January 19, 2021, 10:36:11 am »
Logged
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

Weitentaaal

  • Full Member
  • ***
  • Posts: 113
Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
« Reply #2 on: January 19, 2021, 02:43:14 pm »
Yes but i can only convert 10 mb of the db :/
Logged
Lazarus: 2.0.6 x86_64-win64-win32/win64
FPC-Version: 3.0.4
Compiler Version: 3.2.0

wp

  • Hero Member
  • *****
  • Posts: 8099
Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
« Reply #3 on: January 19, 2021, 03:12:20 pm »
Does the mdb contain macros? If yes, you're out of luck. If not, you can read the tables into ODBC. You'll have to recreate the queries by yourself.
Logged
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

Zvoni

  • Sr. Member
  • ****
  • Posts: 462
Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
« Reply #4 on: January 19, 2021, 04:15:01 pm »
DBeaver?
Logged
One System to rule them all, One IDE to find them,
One Code to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
People call me crazy, because i'm jumping out of perfectly fine aircraft

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
« Reply #5 on: January 26, 2021, 01:09:19 pm »
Logged
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018