1. connect to excel using OleDB2. connect mySql using MySql connector http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3 3. use datareader from Oledb to insert data from excel to MySql database
On Tue, Mar 17, 2009 at 3:39 PM, aadi <downtown...@gmail.com> wrote: > > pls some one guide step by step to import or convert excel sheet data > into mssql database > thanks and regds > annadurai >
