dataset中的数据批量导入oracle数据库,急怎么将DataSet的数据批量插入到Access

C# codetry

{

oracleConnection1.Open();

System.Data.OracleClient.OracleDataAdapter ora_adp = new System.Data.OracleClient.OracleDataAdapter( "select * from clientregiste ",oracleConnection1);

OracleCommandBuilder objCommandBuilder=

new System.Data.OracleClient.OracleCommandBuilder(ora_adp);

ora_adp .DeleteCommand = objCommandBuilder.GetDeleteCommand();

ora_adp .InsertCommand = objCommandBuilder.GetInsertCommand();//如果只是删除操作后更新，

此句和下面一句可以不要

ora_adp .UpdateCommand = objCommandBuilder.GetUpdateCommand();//

DataSet dstobj = new DataSet();

ora_adp.Fill(dstobj, "originally ");

System.Data.DataRow row = dstobj.Tables[ "originally "].Rows[1];

row.Delete();

dstobj.AcceptChanges();

ora_adp.Update(dstobj, "originally ");

oracleConnection1.Close();

}

catch(Exception ora_err)

{

Label1.Text = ora_err.Message;

}

finally

{

oracleConnection1.Close();

}

------解决方案--------------------

试试下面的，再不行的话就得用常规办法了.

Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=C:\Test Files\db1 XP.mdb")

AccessConn.Open()

'New table

Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [tbl1] FROM [Text;DATABASE=C:\Documents and Settings\...\My Documents\My Database\Text].[tbl1.txt]", AccessConn)

'Existing table

'Dim AccessCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO [tbl1] (F1, F2, F3) SELECT F1, F2, F3 FROM [Text;DATABASE=C:\Documents and Settings\...\My Documents\My Database\Text].[tbl1.txt]", AccessConn)

AccessCommand.ExecuteNonQuery()

AccessConn.Close()

The schema.ini file would look something like following:

[tbl1.txt]

ColNameHeader=False

Format=TabDelimited

CharacterSet=ANSI