Exista mai multe optiuni de a obtine datele dintr-un dbf printre care:

1. Definiti un linked server si interogati direct datele din DBF.

2. Folosind SQL Server Integration Services.

3. Folosind OPENROWSET

SELECT * FROM OPENROWSET(
   'MSDASQL',
   'Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\MyDbfFiles\',
   'Select * from MyTableName')

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro