I'm trying to pull data from a Foxpro database into SQL using a ODBC connection with the foxpro driver. It is getting the error:
'ERROR CONVERTING DATA TYPE DBTYPE_DBTIMESTAMP to datetime'
My query is:
FROM OPENQUERY([master_builder], 'select duedte from acpinv') AS ACP_INV
How can I in my select query either cast the data so it comes through or not pull bad dates?
Here's a screenshot if it helps: http://i.imgur.com/V3wKEK2.png