例如:怎样在程序中用代码打开c:\joo\jz.dbf,不用DSN,直接用代码。
偶是这样写的哪里不对请指教。。。
Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.Command
cn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties='Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;SourceDB=c:\joo\jz.dbf;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;'"
cn.Open
cmd.CommandText = "SELECT * FROM jz WHERE [deh] = 1830 "
cmd.ActiveConnection = cn
rs.Open cmd