bulk import a CSV file to MS Access without loop using .net
===

I have a requirement for importing a CSV file into MS Access table. But for inserting the records into the access table I don't want to use loop for one by one insertion. Instead I want to do it something like BULK INSERT.

I have tried the following two approaches but failed:

1) 

        OleDbConnection conn1 = new OleDbConnection("provider = microsoft.jet.oledb.4.0;
        Data Source = E:\\;Extended Properties='text;HDR=No;FMT=CSVDelimited';");
            OleDbDataAdapter da = new OleDbDataAdapter("select * from [abc.csv]", conn1);
            DataSet ds = new DataSet();
            da.Fill(ds);
            OleDbConnection conn=new OleDbConnection("provider = microsoft.jet.oledb.4.0; Data Source = E:\\testdata.mdb");
            //OleDbCommand cmd = new OleDbCommand("insert into table1 as select * from "+ds.Tables[0] , conn);
        OleDbCommand cmd = new OleDbCommand("select * into table1 from " + ds.Tables[0], conn);
        conn.Open();
        int count = cmd.ExecuteNonQuery();
        conn.close();
        conn1.close();

But I am getting the "Syntax error in FROM clause" error in the second query mentioned in OledbCommand().

2) second technique I used is:

        OleDbConnection conn=new OleDbConnection("provider = microsoft.jet.oledb.4.0; Data Source = E:\\testdata.mdb");
        OleDbCommand cmd = new OleDbCommand("select * into table1 from [text;database=e:\\abc.csv]", conn);
            conn.Open();
            int count = cmd.ExecuteNonQuery();
        conn.close();

In this case I got the following error:
The Microsoft Jet database engine cannot find the input table or query 'text;database=e:\abc.csv'.

Please help me out to come out to this problem. I used both of above ways as I think these could be the best way to bulk import the CSV to Access.

Please help me. 
Thanks,
Varun Dutta

