Nannette Thacker ShiningStar.net

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?

What would be do for a 64 Bit Windows system Importing an Excel Spreadsheet .