Is it possible to import tables into a SQL 2000 Database via an ODBC connection? The source files are dBase III (*.dbf) and reside on a different network from the SQL 2000 server. If so, would it then be possible to update those files via the same method?
Yes, the source files are visible via ODBC from the SQL Server. My DB knowledge is limited to SQL Enterprise Manger and Query Analyzer, and after scouring the web I could not find a way to import data via ODBC using either of these.