I have created below query which is inserting the data into SQL from excel. Now the problem which is coming that some places it is showing data like "2.52206e+007".
Please suggest how to correct thks
SELECT [Account No],Curr Ph 1],[Curr Mobile],
'Excel 12.0 Xml;HDR=YES;Database=E:\Upload_Files\Inventory.xls',
'SELECT * FROM [Sheet1$]')