Accessing Excel columns via ADO.NET?

  • Thread starter Thread starter Chris Sells [MSFT]
  • Start date Start date
C

Chris Sells [MSFT]

I'm able to do "select * from [Sheet1$]" without any trouble by following
along with Shawn's article [1]. However, I'd like to do "select teacher,
fname + ' ' + lname, etc from [Sheet1$]" and it's not working. Is this
possible? How do I go about it? Thanks.

Chris Sells
http://msdn.com/longhorn
 
Never mind -- I answered my own question. Selects like "select teacher,
fname + ' ' + lname as name from [Sheet1$]" work just fine. My problem was
with databinding, not the expressions themselves. Thanks for listening. : )

Chris Sells
http://msdn.com/longhorn
 
Back
Top