Search an excel spreadsheet with sql
date date date
6-Feb 7-Feb 8-Feb
Time 6-Mar 7-Mar 8-Mar
1 A B C
2 B C D
My excel page is like the above. I need to look up the month and time and get back the letter using sql. For example it could look up apr and 1.00 and return A or look up mar and 2.00 and bring back D. Any ideas on how to write the sql considering that this is an excel spreadsheet? PS I've already made the connection etc, I just need some clues on the sql?
Last edited by Funkymonkey; 04-06-2006 at 10:10 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)