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'

 

posted @ 2010-06-22 11:48  C.fly  阅读(207)  评论(0编辑  收藏  举报