I have to support a legacy application. I am using an ODBC connection to ACCESS - and want to create DBF files on the fly from ACCESS tables.
SELECT INTO should according to the ACCESS help files work, though not the ideal solution. Assuming an access table named "temp"
SELECT * INTO temp IN [dBASE III; DATABASE=C:\APP] FROM temp
should work, and I should have a DBF named temp created. But it doesn't work. On the other hand
SELECT * INTO temp from temp IN [dBASE III; DATABASE=C:\APP]
does work and will create an ACCESS table from an external DBF.