Anyone use CFX_Excel2Query?

I am using it with this syntax: cfx_excel2query file=#excelfile# r_qResults=orderlist firstRowIsHeader=false columnlist = name,address,city,state,zip The excel file has its own header, which I am trying to overwrite by the one provided with the 'columnlist' attribute. However,

Re: Anyone use CFX_Excel2Query?

Irvin, thanks. I realized that I was using the attributes incorrectly, because that's how another tag, CFX_Text2Query from the same author works. I need to get rid of the user supplied header row and provide my own and there doesn't seem to be an elegant way of doing that with this tag. Irvin

Re: Anyone use CFX_Excel2Query?

Try: cfx_excel2query file=#excelfile# firstRowIsHeader = 1 nodates columnList=columns r_qResults=orderlist That will return a query object called orderlist and a variable named columns that is a list of the column names in your excel file. I am using