dbf是vfp数据库文件,先建立连接在保存倒sql
OLE DB Provider for Visual FoxPro
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp7\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
For more information, see: Microsoft OLE DB Provider for Visual FoxPro To view Microsoft KB articles related to OLE DB Provider for Visual FoxPro, click here.Note: The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it's OLE DB Provider.
Microsoft
Most Valuable Professional
(MVP)
Questions or comments about this web site, please send email to: WebMaster or Feedback
Copyright © 1997 - 2003 Able Consulting, Inc. Terms Of Use
Last Modified: Friday, April 04, 2003 07:44:53 PM
OLE DB Provider for Visual FoxPro
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp7\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
For more information, see: Microsoft OLE DB Provider for Visual FoxPro To view Microsoft KB articles related to OLE DB Provider for Visual FoxPro, click here.Note: The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it's OLE DB Provider.
Microsoft
Most Valuable Professional
(MVP)
Questions or comments about this web site, please send email to: WebMaster or Feedback
Copyright © 1997 - 2003 Able Consulting, Inc. Terms Of Use
Last Modified: Friday, April 04, 2003 07:44:53 PM
oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=c:\somepath"
Then specify the filename in the SQL statement:oRs.Open "Select * From user.dbf", oConn, , ,adCmdText
Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files. (Q238431).For more information, see: dBASE Driver Programming ConsiderationsTo view Microsoft KB articles related to Microsoft dBASE Driver, click here
通过sql语句能读出dbf文件的数据后,如何将数据存入到sql数据库?