Transfer database through ODBC : Access Import Export « Access « VBA / Excel / Access / Word






Transfer database through ODBC

 

Sub TestLinkTransferDatabase()
    DoCmd.TransferDatabase acLink, "ODBC Database", _
        "ODBC;DSN=DataSourceName;UID=username;PWD=pwd;LANGUAGE=us_english;" _
        & "DATABASE=yourDatabase", acTable, "Sales", "dboSales"

End Sub

 








Related examples in the same category

1.Export to a Fixed Width File
2.Importing from a Fixed Width File
3.Export to a Comma Separated File
4.Importing from a Comma Separated File
5.Export table to asp page
6.Export table as html page
7.Export table as htx file
8.Export table as rtf file
9.Export table as txt file
10.Export table as xls file