I'm using access tables to store my data. to retrive data I use jet odbc engine in c++.

I want to insert a large amuont of records (about 20 mega records) to my database in the fasts way i can. if i use sql syntax (insert into table ()....) it's takes for ages (about 500 records per second).

if i'm writing a csv file and then use import (via access) it's much faster but still takes a long time, i can live with that only i dont know how to use the access import tool from c++.

does any know any tool that insert records in an optimize way, or how to use the access import tool in c++? can i use the jet engine for it?

thank ishay