Link FoxPro Table in Access 2000 using ADO 
Author Message
 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



Tue, 01 Feb 2005 02:50:13 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Link FoxPro Table to Access 2000 Progammatically

2. ADO - Error querying linked database tables in ACCESS 2000

3. Access 2000 using linked tables

4. Linking Access 2000 Table to Outlook 2000 Tasks

5. Add fields to an Access 2000 Table on the fly using ADO 2.1

6. Create Dynamic Table in Access 2000 using ADO

7. Modify Access 2000 table structure using ADO in VB6

8. HELP!!..accessing access 2000 with linked SQL Server tables

9. Using FoxPro 3.0 tables in VB using ADO

10. Link SQL server table to Access using ADO

11. ADO using 3.51 with Links to Access 97 tables

12. Access to SQL/Oracle database using ADO and linked table

 

 
Powered by phpBB® Forum Software