Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Displaying the Uploaded Excel Spreadsheet

By Nannette Thacker

In the third installment of this tutorial, we discuss how to bind the contents of our uploaded Excel spreadsheet to our GridView. A Zip file with the complete source code, Excel Spreadsheet, and SQL Server Database is available for download.

The article series hosted on 4guysfromrolla.com continues with Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Displaying the Uploaded Excel Spreadsheet.

Download the Application in ZIP Format


May your dreams be in ASP.NET!

Nannette Thacker

3 Comments

  • Nannette,
    I was reading your series on Importing an Excel Spreadsheet Using Typed Datasets and Table Adapters, it is very good so far... I'm looking forward to the rest of the series.  I just this morning read the third part - "Displaying the Uploaded Excel Spreadsheet".  I do have one item to share.
    On a 64 Bit Windows system, there is no longer support for the Jet Engine.  We ran into this recently when we upgraded hardware to 64 Bit Windows Server 2003.  Our options were to force IIS to run in 32 Bit Compatibility mode which is a service level change, purchase a third party library allowing us to query excel, run a web service on a 32 bit system (or with IIS running in 32 Bit mode) to simply act as a proxy to parse an excel file and return the results, or compile a 32 Bit Console Application and have our web application do a system call to it.  Just an FYI for you...
    Thanks for your writings, they are very informative and helpful!
    Jason

  • Nannette,

    I was reading your series on Importing an Excel Spreadsheet Using Typed Datasets and Table Adapters, it is very good so far... I'm looking forward to the rest of the series. I just this morning read the third part - "Displaying the Uploaded Excel Spreadsheet". I do have one item to share. On a 64 Bit Windows system, there is no longer support for the Jet Engine. We ran into this recently when we upgraded hardware to 64 Bit Windows Server 2003. Our options were to force IIS to run in 32 Bit Compatibility mode which is a service level change, purchase a third party library allowing us to query excel, run a web service on a 32 bit system (or with IIS running in 32 Bit mode) to simply act as a proxy to parse an excel file and return the results, or compile a 32 Bit Console Application and have our web application do a system call to it. Just an FYI for you...

    Thanks for your writings, they are very informative and helpful!

    Jason

  • When testing the code on a Vista machine with Office 2007, I get a security exception error. Have you updated the code for this environment yet?

Comments have been disabled for this content.