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