Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
incorrect format when import excel to table
June 10, 2011
hi I am import excel field to database table but in my table. the account number field is not correct format in my database table like this coming 5.001e+011. I have changed in excel account column format in number but error coming
Posted Date: June 10, 2011 Points: 20
Hi Catherine ,
I hope this will help you, try this.
using System.Globalization;// need to use the namespace.
string s = "5.001e+011"; //Here, you have to assign the Value which is retrieved from your excel file.
decimal.TryParse(s, NumberStyles.Any, null, out amount1);
Then you can store the " amount1 " into your database table.
To post reply
Related Questions Related Questions
import excel file into sql database table
how to import a data from Excel sheet to sql server table
Excel Import from IIS server
To convert tally files into excel format
how will we convert the excel files into text format by using .net
How to Import and export Excel sheet in ms access 2003 by command (button) clicking
How to import text file in Excel
Excel 2007 Import - xlsb
Insert excel field into table using stored procedure
excel to table update prefix zero problem
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend