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.
The only SQL functionality in Excel is to allow you to attach a database lookup into a cell in your worksheet. There is no SQL functionality for searching the worksheet itself.
I thought I vaguely remembered some way to query Excel sheets via some ODBC connection? I'm off to msdn to see if I can refresh my memory (or confirm its well-known defectiveness)....
Last edited by NogDog; 04-06-2006 at 09:13 PM.
I think for your spreadsheet to function as a database, the very first row needs to be column names, thus each column of the first row should have a distinct value. I'm not sure what restrictions might be on column names, but it would probably be best to start with a letter, and only use letters, digits, and underscores for the name.
For whatever it's worth, in its comparatively short lifetime the SQL forum is close to passing the Accessibility, Dreamweaver/Frontpage, and Domain Names forums in number of threads.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)