G
Guest_lik_
подскажите, плз, как объединить несколько dbf-таблиц,ODBC подвел..
Код:
Set cnn1 = New ADODB.Connection
Set rst1 = New ADODB.Recordset
ssql = "select * INTO new11.dbf FROM (select * from uni1.dbf union all select * from uni1.dbf)"
cnn1.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=" & "c:\temp" & ";" & _
"Exclusive=No"
'здесь выдает: ODBC driver does not support the requested properties
rst1.Open ssql, cnn1, adOpenKeyset, adLockOptimistic