Last post Jun 28, 2010 04:47 AM by jessajr
Jun 28, 2010 04:47 AM|jessajr|LINK
I want to transfer data from excel file to mysql but Im not good in asp.net, im still in the process of learning. I try to use this code but this only read the data on my excel file. Is it possible that I will only select column of data that I need to
transfer in mysql. Based from this code how can upload data to my sql then showing it to a data grid selecting only column that I need. Thanks.
''You can also use the Excel ODBC driver I believe - didn''t try though
"Extended Properties=""Excel 8.0;"""
''You must use the $ after the object you reference in the spreadsheet
DataGrid1.DataSource = myDataset.Tables(0).DefaultView