I ended up having to first move the data into a table with all the date columns typed as Char. Then, you can check the dates to make sure they will fit into the datetime/smalldatetime ranges.

E.g. if the date in the foxpro table is 1215-01-01, SQLServer won't like it.

Teague