using an ODBC dbf connection in the import/export wizard, I am finding that I
am unable to use traditional SQL syntax in the "Provide a Source Query"
dialog. Specifically, while:
select * from CY_1000.DBF
works fine, if I try to write any syntax (such as a join clause) that
requires referencing fields in multiple files/tables, it fails.
I assume the issue is the period in the file name, since it then doesn't
know how to handle CY_1000.DBF.FIELDONE but [CY_1000.DBF].[FIELDONE] doesn't
work either. What is the correct syntax to use in this dialog?