The following imports, only the first unsuccessful, second / three successful select * from openrowset ('msdasql', 'driver = Microsoft Visual FoxPro Driver; SourceType = DBF; SourceDb = C: /', 'Select * from [kehu.dbf ] ') --- Tip does not support this feature, FAINT
Select * from openDataSource ('microsoft.jet.oledb.4.0', 'data source = c: /; user ID = admin; password =; extended Properties = DBASE 5.0') ... kehu
Select * from OpenDataSource ('vfpoledb.1', 'data source = c: /') ... kehu
Pay attention to the data type problem when importing, if there is a data type that SQL Server does not support, the metadata conversion error will be prompted, the import is unsuccessful (7356), in which case I choose to use the import export tool to complete, there is also a problem in use There is an empty date (是} instead of null) in the VFP. In this case, an error will occur.
