pcsoft.us.windevCopyright 2026, PC SOFT12 Oct 2016 06:35:00 Z7 Oct 2016 11:53:00 ZHello everyone !! I need to export a table to SQLite from fic file . The fic file contains around 100000 rows with some columns with encrypted text (binary data) . Any suggestion !! I tried HAdd (tablename) after connecting to sqlite with native access. It takes around one hour to add 1000 rows. There must be some alternatives !! Thanks !!30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59930/read.awp12 Oct 2016 06:35:00 ZHello Binod, Why not build queries based on the data in HFSQL .FIC file and then execute the queries on SQLite. This would…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59930/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59930/read.awpdata import/ exportguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59858/read.awp7 Oct 2016 12:53:00 ZHi, Is there a way to drop your indexes from the SQLite database before you start the import? This would probably speed it up…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59858/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59858/read.awpdata import/ exportguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59857/read.awp7 Oct 2016 12:41:00 ZHi, use HTransactionStart en HTransactionEnd and put all your HAdd's in between. That should speed up things. Otherwise Wind…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59857/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59854-data-import-export-59857/read.awpdata import/ export