Larry, thank you...worked like a charm.
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.
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications Group
Internet Division
------------------------------------------------------------------------------
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.
