Read excel fiels using ado.net in Vb.net?

If you wish to use ADO, the data provider is available to connect to EXCEL file. Microsoft Jet is one of the best ones Otherwise, you can use EXCEL object itself for any other manipulation if needed.

If you wish to use ADO, the data provider is available to connect to EXCEL file. Microsoft Jet is one of the best ones. Otherwise, you can use EXCEL object itself for any other manipulation if needed.

I need the code for tht – Binu Feb 15 '10 at 11:33 You can reefr my other answer for the code. – Kangkan Feb 15 '10 at 11:46.

You can see the following and think in that line: string connectionString = @"Provider=Microsoft.Jet. OLEDB.4.0;Data Source=Book1. Xls;Extended Properties=""Excel 8.0;HDR=YES;"""; DbProviderFactory factory = DbProviderFactories.

GetFactory("System.Data. OleDb"); using (DbConnection connection = factory. CreateConnection()) { connection.

ConnectionString = connectionString; using (DbCommand command = connection.CreateCommand()) { // Cities$ comes from the name of the worksheet command. CommandText = "SELECT ID,City,State FROM Cities$"; connection.Open(); using (DbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { Debug. WriteLine(dr"ID".ToString()); } } } }.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.