Excel to sql...........
-
Hi, I want to convert excel sheet data to sql database.I have completed it using OLEDB connection and sql query.I retrieved the data from excel and bind the data into dataset using OLEDataAdapter and then dataset content will be displayed on grid.If the excel sheet data is of same datatype means it is working properly.See the excel sheet example... Name Mark1 Mark2 Ram 87 76 somu 45 65 james 65 98 When converting this excel to sql it is working properly.. See the problem below.. Name Mark1 Mark2 Ram 87 76 somu 45 AB james 65 98 when i am giving 'AB' to mark it shows null value at that specified column(ie,blank space on grid for the data 'AB'). This is my problem...How can i rectify this....Any alternative solutions... Thanks in Advance
-
Hi, I want to convert excel sheet data to sql database.I have completed it using OLEDB connection and sql query.I retrieved the data from excel and bind the data into dataset using OLEDataAdapter and then dataset content will be displayed on grid.If the excel sheet data is of same datatype means it is working properly.See the excel sheet example... Name Mark1 Mark2 Ram 87 76 somu 45 65 james 65 98 When converting this excel to sql it is working properly.. See the problem below.. Name Mark1 Mark2 Ram 87 76 somu 45 AB james 65 98 when i am giving 'AB' to mark it shows null value at that specified column(ie,blank space on grid for the data 'AB'). This is my problem...How can i rectify this....Any alternative solutions... Thanks in Advance
first filter it out then type convert.