Access VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Access
  4. 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