Code Bank
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingCode Bank

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #16  
Old May 15th, 2007, 01:22 PM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
Click here for more information.
 
Join Date: Feb 2005
Location: Dreamland
Posts: 12,645 mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 3 Weeks 5 Days 18 h 58 m 26 sec
Reputation Power: 1542
yes ... as long as table name is worksheet name, and you have column headings. it's as if it's a regular database.
__________________
Come JOIN the party!!!

Quote of the Month:
Stupidity: Quitters never win, winners never quit, but those who never win AND never quit are idiots.

Questions to Ponder:
If man evolved from monkeys and apes, why do we still have monkeys and apes?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright© 2008 sbenj69

Reply With Quote
  #17  
Old May 15th, 2007, 01:33 PM
stscac stscac is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 11 stscac User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 20 m 33 sec
Reputation Power: 0
Great. Thanks for the help

-Steve

Reply With Quote
  #18  
Old May 22nd, 2007, 11:42 AM
Ben Hofmann Ben Hofmann is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 2 Ben Hofmann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 8 sec
Reputation Power: 0
Anybody know if you can sort by multiple criteria?

Here is code from a project I'm working on for a employee list by department.

Code:
strSQL = "SELECT * from photorange ORDER BY [Department]"


I would like to order first by department, then by last name similar to what Excel will do with a data sort with multiple criteria. How would I do this?

-Ben

Reply With Quote
  #19  
Old May 22nd, 2007, 11:47 AM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
Click here for more information.
 
Join Date: Feb 2005
Location: Dreamland
Posts: 12,645 mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)mehere User rank is General 8th Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 3 Weeks 5 Days 18 h 58 m 26 sec
Reputation Power: 1542
just add the additional sort options at the end
Code:
strSQL = "SELECT * from photorange ORDER BY [Department], [LastName]"

Reply With Quote
  #20  
Old May 22nd, 2007, 05:32 PM
Ben Hofmann Ben Hofmann is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 2 Ben Hofmann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 8 sec
Reputation Power: 0
That was easy. Thanks!

-Ben

Reply With Quote
  #21  
Old April 9th, 2008, 09:18 AM
ajayp40 ajayp40 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Aug 2007
Posts: 130 ajayp40 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 21 h 26 m 31 sec
Reputation Power: 1
Small tip for people reading over this this line of code

Code:
strSQL = "SELECT * FROM A2:Q10000"


Is where you can change the tables cords depending on how many rows you have in your excel spreadsheet allowing you to have more rows or collumns.

A2:Q10000

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingCode Bank > Classic ASP: read Excel file into Recordset


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway