Ed;
Thanks for the feedback. Is there a different set of SQL commands I can
reference for the Jet.OleDB engine?

"Ed Ferrero" wrote:

Hi Parrot,

I finally figured out to use column heading names from Excel for my
selection
testing but now I find that I am limited in my SQL commands. For example,
if
I use the command ... WHERE SUBSTRING(field1, 1,1) = 'F' I get an error
complaining about the SUBSTRING. I guess if you use the Jet Engine to
open
the file, you do not have the full capabiliites of the SQL commands. Is
this
true?

True. Use LEFT(field1,1)='F' instead.

Ed Ferrero
www.edferrero.com