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 1801 times)

Weitentaaal

  • Hero Member
  • *****
  • Posts: 516
  • Weitental is a very beautiful garbage depot.
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

JD

  • Hero Member
  • *****
  • Posts: 1848
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 - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)

mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView

Weitentaaal

  • Hero Member
  • *****
  • Posts: 516
  • Weitental is a very beautiful garbage depot.
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

wp

  • Hero Member
  • *****
  • Posts: 11911
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

Zvoni

  • Hero Member
  • *****
  • Posts: 2327
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 Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

JD

  • Hero Member
  • *****
  • Posts: 1848
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 - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)

mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018