Create Link Table in Access VBA

To create Link Table in access through VBA script we can use
DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;Driver={SQL Server};Server=192.168.0.100;UID=username;PWD=password;LANGUAGE=us_english;" & _
"DATABASE=databasename", acTable, "SQLsourcetablename", "AccessDestinationTableName"

No comments:

Post a Comment