Michael R Mattys
mmattys at rochester.rr.com
Fri Nov 30 12:35:25 CST 2007
I figured out what went wrong, but I still don't like it: The imported table name is also called CASS The SQL I used to create the table was SELECT TRIM([ID]) AS ID, ... INTO CASS FROM CASS IN 'dbpath' No error occurred in the code, but manually creating the query tells me that TRIM([ID]) AS ID is a circular reference. It created the table anyway, it just refused to Trim. ?? (I did not use On Error Resume Next) Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com