Import excel data into oracle table using windows C# forms

Question

Hi Experts, I need to read data from excel file and import into one table of oracle for updating purpose, can anyone help me as i new to C#.I have recently started learning about c#. Thanks.

Manav Pandya · Answer

Hello You should implement by your self , so will learn something new And try and use code given by me Thats it , thanks

Uehara Ayaka · Answer

see this article http://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database

Gautam Parmar · Answer

private void btnChooseFile_Click( object sender, EventArgs e) { string filePath = string .Empty; string fileExt = string .Empty; OpenFileDialog file = new OpenFileDialog(); //open dialog to choose file if (file.ShowDialog() == System.Windows.Forms.DialogResult.OK) //if there is a file choosen by the user { filePath = file.FileName; //get the path of the file fileExt = Path.GetExtension(filePath); //get the file extension if (fileExt.CompareTo( ".xls" ) == 0 || fileExt.CompareTo( ".xlsx" ) == 0) { try { DataTable dtExcel = new DataTable(); dtExcel = ReadExcel(filePath, fileExt); //read excel file dataGridView1.Visible = true ; dataGridView1.DataSource = dtExcel; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } else { MessageBox.Show( "Please choose .xls or .xlsx file only." , "Warning" , MessageBoxButtons.OK, MessageBoxIcon.Error); //custom messageBox to show error } } }

Arif Mohammed · Answer

Hi Manav, Thanks for your help, i need step by step process like adding button, choosing excel file and then load into oracle table. Thanks Arif

Manav Pandya · Answer

Hello You will surely get idea about that be refering following article : http://www.nullskull.com/q/10372916/insert-excel-sheet-data-into-oracle-table.aspx http://www.nullskull.com/q/10229198/insert-data-into-oracle-database-from-excel.aspx http://www.dotnetfunda.com/forums/show/12475/how-to-import-data-from-excel-sheets-to-oracle-and-sql-server Thanks

Import excel data into oracle table using windows C# forms

Answers (5)