>Hi there, I need to update some fields in a SQL table from a Fox dbf two or three times daily , I currently do this using a linked server and SQL agent but it's proving to be very unreliable - SQL reports that an ODBC error has occurred - low on memory etc etc... and only restarting SQL server will fix it, sometimes it runs for a week without a problem other times only for a day, is there any way to use DTS to perform an update ( I know you can insert and copy ) ?
You can try VFP linked server over VFP OLE DB provider.
--sb--