Recent content by ishaywei

  1. I

    optimize insert to access DB

    any one please??? :eek: any one please???
  2. I

    Import Into Access Tables Using ODBC

    I cant use the the Access app, because i need to import the data via c++ code. and in the furtre i need to distribute my software to my clients so i cant even use an API the access install. what I can do is to use the ODBC jet engine - free ODBC engine
  3. I

    Import Into Access Tables Using ODBC

    Hi, I want to import into an MDB table a csv file. I'm trying to use the bulk copy table. my function is: SQL = "SELECT * INTO [my_table] FROM [ODBC;Driver=Micrsoft text driver (*.txt; *csv) ;Dbq=c:\\;Extensions=asc,csv,tab,txt;].table.csv" db.OpenEx( "Driver=Microsoft Access Driver...
  4. I

    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...
Back
Top Bottom