RE: [sqlite] transfer data from an MDB file to SQLite

2004-11-04 Thread Edovia Technologies
Wow! Now takes about 5 seconds! Thanks! Luc -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: November 4, 2004 3:46 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] transfer data from an MDB file to SQLite Edovia Technologies said: > It works, although it ta

[sqlite] transfer data from an MDB file to SQLite

2004-11-04 Thread 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, ); 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

[sqlite] SQLite manager for Windows

2004-11-03 Thread Edovia Technologies
Hi, Anyone knows about a SQLite 3 manager for Windows? The only ones I've found so far seems to only be compatible with SQLite 2. Thanks! Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com