optimize insert to access DB

Hi,

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 here I have two problems

1.I dont know how to use the access import tool from c++.

2.I dont think I can distributie the access import tool with my product.

so my questions are :

1. Does any know any tool that insert records in an optimize way?

2. How can I use the access import tool in c++?

3. Can i use the jet engine to import csv files?

thank ishay

This forum is dedicated to SSIS. You may get better luck asking this question in the appropriate forum.

You could use SSIS to do this, and it should bulk insert into Access using the OleDB Destination Component. You won't be able to distribute it to your users though.

Could you mark this thread as answered if you have no further questions so we can close it out? Thanks!