RE: hmmm...querying an xls file

[Ron Mast]

Got it, answered my own question.  Thanks a million Matt!   Ron Mast Webmaster Truth Hardware Ph: 507-444-4748 Fx: 507-444-5361 www.truth.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Woodward Sent: Friday, May 20, 2005 8:28 AM To: list@dfwcfug.org Subject: Re: hmmm...querying an xls file   The main thing to know is that Excel has workbooks, and your "table name" is the name of the workbook in the Excel file.  You have to refer to the workbook name in quotes and put a $ and the end of it.  Also, you'll need to put headers in the first row of your workbook that become your "column names."   For example, if you have a workbook in your Excel file called Users and it has column headers of FirstName, LastName, and Email, you query it like this (assuming the datasource is configured correctly): SELECT FirstName, LastName, Email  FROM "Users$"   In that case of course you could also do a SELECT *, I just output each column name so you could see how it works.   Hope that helps, Matt   On May 20, 2005, at 8:17 AM, Ron Mast wrote: Good morning all, I have an xls file that I’d like query.  It’s not obvious to me how.  Can someone send me an example query?  I have created the DSN. Thanks in advance.   _______________________________ This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual to whom they are addressed.  If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.