I'm sure there are many tools to help you do this, but I still made another. Based on the DBF structure program will create a table in SQLite database, and transfer data, 1: 1, and you later make optimize
The result is a program that you need to compile
First step: compile imp_gen.prg
Second: compile result program
File sql1.prg you can found on c:\hmg\samples\hfcl\sql\sqlite // author Rathinagiri
p.s. in hmg folder, in file hmg.hbc line #libs=hbsqlit3 remove #
import dbf to SQLite
Moderator: Rathinagiri
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
import dbf to SQLite
- Attachments
-
- import3.zip
- (3.55 KiB) Downloaded 455 times
Last edited by dragancesu on Fri Sep 11, 2015 4:48 pm, edited 2 times in total.
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: import dbf to SQLite
Thanks a lot for the sharing.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: import dbf to SQLite
+1Rathinagiri wrote:Thanks a lot for the sharing.
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
- danielmaximiliano
- Posts: 2612
- Joined: Fri Apr 09, 2010 4:53 pm
- Location: Argentina
- Contact:
Re: import dbf to SQLite
Thanks a lot for the sharing Dragan
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
- serge_girard
- Posts: 3167
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact: