By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,876 Members | 1,239 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,876 IT Pros & Developers. It's quick & easy.

GridView exported to Excel can't be read using OleDb

P: n/a
I am finding that when a GridView is export to Excel by changing the
ContentType of the page the Excel file is not readable by OleDb or SQL
Server DTS. I also tried using a Excel Reader that I found (http://
www.codeproject.com/csharp/Excel_DataReader.asp) but this also threw
an error trying to read the header. I believe that this is all
happening because the exported Excel file is in some sort of html
table format. Does anyone know anything about this and how I might
solve this problem?

If I create a blank Excel file from scratch and then write in some
header and values the file can be read, just not the exported file.

Thanks

Nov 7 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.