upload excel and work with data in code behind

Posted on 2009-04-29
Last Modified: 2013-12-17
I would like a user to be able to upload an excel document on an aspx page.
In code behind (C#)  I would like to check the data and send to database.
How can I do this?
Question by:johnkainn
    LVL 53

    Expert Comment

    I would do it in different steps:
    1. Uploading Files in ASP.Net Using C# and Saving to the Server

    2. Reading that excel from the server-harddisk
    Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory

    LVL 53

    Accepted Solution


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now