SSIS import foxpro dbf file

1. Add a OLE DB Source.

2.Create a new conneciton

3.Set provider to Jet 4.0 OLE Provider

4.Select the database file name and  update path to the related folder name.

5.Set the 'All' property

6.Set the extended properties to 'DBASE 5.0'

原文地址:https://www.cnblogs.com/Excellentchen/p/1762542.html