How to import data from MS Excel to SQL database by ASP.Net

Posted by Krishnasamy2008 under ASP.NET on 7/27/2011 | Points: 10 | Views : 2926 | Status : [Member] | Replies : 2
Hi Friends,
For example, already added a long list of contact people (name, phone, email, address...) in an excel file, how can I just upload the excel file to transfer the data to a table on the SQL server by ASP.Net code?I need to check below condition in my code.I have solution between 4 to 6.

1)Duplicate checking for existing value
2)Checking Excel Column name
3)If email already exists then popup confirmation message either for ("Delete & Add" or "Add" only)
4)Required field validation
5)size validation
6)Extension validation

Any help will be most appreciated!

Thanks,
Krishna.K




Responses

Posted by: Gsudhesh on: 7/27/2011 [Member] Starter | Points: 25

Up
0
Down

check out the following links...

http://support.microsoft.com/kb/321686

Krishnasamy2008, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vforvijay on: 7/27/2011 [Member] Starter | Points: 25

Up
0
Down
hi..try this below link..for import excel table....
http://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html

Krishnasamy2008, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response