Link FoxPro Table in Access 2000 using ADO
Hello,
How do convert this code to ado ?
Sub Vincula_tabela(filename)
' Vinculate table to access database using dao
Set database = CurrentDb
Set tabela = banco_dados.CreateTableDef(filename)
tabela.Connect = _
"ODBC;DSN=Tabelas do Visual
FoxPro;UID=;PWD=;SourceDB=C:;SourceType=DBF;Exclusive=No;BackgroundFetch=No;
Collate=MACHINE;Null=Yes;Deleted=Yes"
tabela.SourceTableName =filename
banco_dados.TableDefs.Append tabela
banco_dados.TableDefs.Refresh
End Sub
------------------------------------------------------
Thank's
Cristiano