Mega Code Archive

 

Categories / VisualBasic Script / Access

 

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