www.webdeveloper.com
Results 1 to 5 of 5

Thread: Search an excel spreadsheet with sql

Threaded View

  1. #1
    Join Date
    Jan 2005
    Posts
    209

    Question 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?

    Thanks!
    Last edited by Funkymonkey; 04-06-2006 at 10:10 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles