> Yes you can query the sheet:
>
> <CFQUERY NAME="GetInfo" DATASOURCE="MyExcel">
> SELECT WhatevercolumnNames
> FROM `Sheet1$`
> WHERE this = this
> </cfquery>
>
> You have to be certain of the reverse single quote before the
> sheet name and after the dollar sign.
OK, just for the record - you can use [ and ] instead of ` around the sheet
name, but they MUST be there
Also, as ODBC won't release the Excel spreadsheet, even if you chuck it a
duff query, it's a lot easier to use Access to point at the spreadsheet
file, and then you can replace it whenever you want without any problems. I
ran into this issue a couple of months back.
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
