 | | |||||
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
| ||||||||
| Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics. |
 |
 |
| | LinkBack | Thread Tools |
05-22-2007, 11:41 AM
| THREAD STARTER #1 (permalink) |
| A Wealth of Knowledge  Join Date: Aug 2004
Posts: 3,809
    | Parsing Excel with ASP Looking for a hand parsing Excel with ASP. I just started to work with ASP this month and now I've been assigned stuff like the following. Probably not too hard for someone that knows ASP in and out, but for me  ????: NamePros.com http://www.namepros.com/programming/330729-parsing-excel-with-asp.html Code: strSQL = "SELECT * FROM A1:Z200 WHERE The_Number <> 'Number 6'" The error is 0x80040E10 "Too Few Parameters" I'll be giving a small bounty to the person that gets this to work. Reply and I will get back to you.  -Steve |
|
|
05-22-2007, 12:42 PM
| #2 (permalink) |
| NamePros Regular  Join Date: Jul 2005 Location: Tucson, AZ
Posts: 689
| I'm confused with what The_Number really is...if it's just a header name, you probably have something wrong. Try using the column index, like "...WHERE B <> 'Number 6'. Did you somewhere else in the code map that column index to the index in the excel file? |
|
|
