note 12720 deleted from ref.odbc by sniper
| From: | sniper@php.net | Date: | Tue, 04 Nov 2003 00:37:22 +0000 |
| Subject: | note 12720 deleted from ref.odbc by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-59756@lists.php.net to get a copy of this message | ||
Note Submitter: pgodel@lticom.com
----
This sounds stupid, but took me a good bunch of time to figure it out..
If you want to do a select on an excel file through ODBC,
"SELECT * from [Sheet1$]"
Where Sheet1 is the name of the sheet inside the .xls file.
Hope this helps.