It is easy to import the DBF (VPF) file to SQL2000

There is a software to be re-developed. It was previously written in Visual Foxpro, and the database is in DBF format. net rewrite, and then, the database is changed to SQL Server 2000. I don't know how to reverse the data. I didn't have any idea at the time, and then I went to Google to discover the New World, there is a very convenient method (I don't know how convenient it is), the Code is as follows (look at other people's, however, the help of SQL Server 2000 ):

Select * into BmK
From OpenDataSource ('Microsoft. jet. oledb.4.0 ', 'Data source = "E: \ share"; user id = admin; Password =; extended properties = DBASE 5.0 ')... bmK
In this way, you can import the BmK. DBF table in E: \ share to sqlserver at the fastest speed.

I used it too. It's very convenient. Really !!