Transfer SQLServer database : SQLServer « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. SQLServer

Transfer SQLServer database

 

Sub TestTransferSQLDatabase()
    DoCmd.TransferSQLDatabase _
        Server:="ServerName", _
        Database:="Pubs", _
        UseTrustedConnection:=True, _
        TransferCopyData:=False

End Sub








Related examples in the same category

1.Connecting to an SQL Server Database
2.Connecting to an SQL Server Using a DSN-less Connection
3.DSN-less connection using the SQLOLEDB provider
4.Creating a SQL Server Connection Object with SQL Server Security
5.Creating a SQL Server Connection Object with Integrated Security