accessing xl sheet data through .NET c#

Question

i want to access the cells of excel sheet in .NET c# as we do in case of oracle database. is there any code to convert xl data to oracle.please reply as early as possible.

Bechir Bejaoui · Answer

Not at all you're welcome ; )

Bechir Bejaoui · Answer

Not at all you're welcome ; )

Bechir Bejaoui · Answer

Not at all you're welcome ; )

shruti balapgol · Answer

thankyou so much this code has solved my problem string connectionString1 = Dsn=scott;uid=system;pwd=query ; System.Data.Odbc. OdbcConnection con = new System.Data.Odbc. OdbcConnection (connectionString1); System.Data. DataSet dsOracle = new System.Data. DataSet (); string ConnectionString = @Provider=Microsoft.Jet.OLEDB.4.0;  + Data Source= + C:\TBL_STUD_EMP_REC.xls + ; + Extended Properties='Excel +  8.0;HDR=NO;IMEX=1;' ; string CommandText = select * from [sheet1$] ; OleDbConnection myConnection = new OleDbConnection (ConnectionString); OleDbCommand myCommand = new OleDbCommand (CommandText myConnection); myConnection.Open(); OleDbDataReader reader = myCommand.ExecuteReader( CommandBehavior .CloseConnection); while (reader.Read()) { System. Console .WriteLine(reader[0].ToString()); string query = INSERT INTO SCOTT.TBLSTUDEMPREC values(' + reader[0].ToString() + '' + reader[1].ToString() + '' + reader[2].ToString() + ') ; //' + reader[3].ToString() + '); //values(2'rini''pune'); con.Open(); System.Data.Odbc. OdbcCommand cmd = new System.Data.Odbc. OdbcCommand (query con); System.Data.Odbc. OdbcDataAdapter adpt = new System.Data.Odbc. OdbcDataAdapter (cmd); adpt.Fill(dsOracle); con.Close(); }

Bechir Bejaoui · Answer

http://oraclebizint.wordpress.com/

shruti balapgol · Answer

s i want to read from excel and write it to oracle

Vijaya Kadiyala · Answer

Hi You want to read the data from excel or insert the data into Oracle? Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

Bechir Bejaoui · Answer

The question is not clear You want to access an Excel file or Transfer data from excel to oracle by using insert into SQL request

Sateesh Arveti · Answer

Hi You can use either Excel Interop library or oledb provider to read excel data.After reading the data into a datareaderloop through it and insert into oracle table as shown below: string ConnectionString = @Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\spreadsheet.xls; Extended Properties=Excel 8.0;; string CommandText = select * from [sheetName]; OleDbConnection myConnection = new OleDbConnection(ConnectionString); OleDbCommand myCommand = new OleDbCommand(CommandText myConnection); myConnection.Open(); OleDbDataReader reader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { //name =reader[0].ToString(); //Oracle Insert stmt here with values got from reader object. }