[sqlite] transfer data from an MDB file to SQLite

[Edovia Technologies]

Hi!

 

So far, what I do is that I go through each record of a table in a MDB file
and use 

sqlite3_exec( m_pDB, "INSERT INTO...", 0, 0, &szError ); 

to transfer each record to my SQLite db.

It works, although it takes quite a while to transfer data. Like about a
minute for 500 records! 

I'm sure there's a better way. Anyone knows?

Thanks!