Recent

Author Topic: Database convert tool  (Read 292 times)

Weitentaaal

  • Jr. Member
  • **
  • Posts: 82
Database convert tool
« on: October 29, 2020, 02:43:07 pm »
Hey Guys,

is there any Tool to convert access Databases to SQLite DB's, or do i have to write one ?
and if i have to write one, how do i read a .mdb file ?

Thanks
ModdyMC Studio

lucamar

  • Hero Member
  • *****
  • Posts: 3454
Re: Database convert tool
« Reply #1 on: October 29, 2020, 02:48:58 pm »
Google "convert access to sqlite" and you'll find quite a lot of tools for that.

As for reading Access database (.mdb, etc) it can be done with the standard Lazarus DB components. Only, IIRC, it has to be done with an ODBC connector, since there are no direct components as for SQLite, Firebird, MySQL, etc.
Turbo Pascal 3 CP/M - Amstrad PCW 8256 (512 KB !!!) :P
Lazarus/FPC 2.0.8/3.0.4 & 2.0.10/3.2.0 - 32/64 bits on:
(K|L|X)Ubuntu 12..18, Windows XP, 7, 10 and various DOSes.

Weitentaaal

  • Jr. Member
  • **
  • Posts: 82
Re: Database convert tool
« Reply #2 on: October 29, 2020, 04:01:49 pm »
Yes but every tool just converts 50% of the db :/

But Thanks for ur Help

 

TinyPortal © 2005-2018