c# - Bulk import from MS Access and Insert into Sql Server -

i want read records ms access database , insert sql server database, process should bulk insertion. i'm using asp.net/vb.net

first of read data excel sheet

connectionstring = "provider=microsoft.ace.oledb.12.0;data source=" + server.mappath("~/temp/") + "filename.xlsx; extended properties=excel 12.0;";  dbproviderfactory factory = dbproviderfactories.getfactory("system.data.oledb");         dbdataadapter adapter = factory.createdataadapter();         dbcommand selectcommand = factory.createcommand();         selectcommand.commandtext = "select columnnames [sheet1$]";         dbconnection connection = factory.createconnection();         connection.connectionstring = connectionstring;         selectcommand.connection = connection;         adapter.selectcommand = selectcommand;         datatable dtbl = new datatable();         adapter.fill(dtbl);  // use sql bulk query insert data          if (dtbl.rows.count > 0) {   using (sqlbulkcopy bulkcopy = new sqlbulkcopy(destconnection))         {             bulkcopy.columnmappings.add("columnname", "columnname");             bulkcopy.columnmappings.add("columnname", "columnname");         bulkcopy.destinationtablename = "dbtablename";         bulkcopy.writetoserver(dtblnew);     } }