---
title: "Copy SQL Server table"
slug: "copy-sql-server-table"
description: "Copy a SQL Server table to another database from inside Excel, either the table structure on its own or the structure together with its data."
updated: 2023-07-14T13:07:20Z
published: 2023-07-14T13:07:20Z
canonical: "sqlspreads.com/copy-sql-server-table"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Copy SQL Server table

This feature allows you to copy an existing SQL Server table in a database to another database. You can optionally choose to just copy the table itself, or the data in the table also.

To access this feature, click on the **Copy SQL Server table** button in the SQL Server Tools menu.

![SQLServerTools_RibbonMenuButton3.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_RibbonMenuButton3.png)

The **Copy SQL Server table** dialog is shown below:

![SQLServerTools_CopyTableDialog.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_CopyTableDialog.png)

### Copy table

From the **Copy SQL Server table** dialog, first select the table that you want to copy, then the destination database for the copied table.

![SQLServerTools_CopyTable_Basic.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_CopyTable_Basic.png)

You can choose a table from a database on the currently connected server, or from a different server. To select a different server, click on the **Edit Server** button and then select a server to connect to.

![SQLServerTools_CopyTable_EditServer.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_CopyTable_EditServer.png)

When you select the destination for the copied table, you can also choose to create a new database instead of selecting an existing one. To create a new database, click on the **Create new database** button.

![SQLServerTools_CopyTable_CreateNewDatabase.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_CopyTable_CreateNewDatabase.png)

By default, SQL Spreads will create the newly copied table in the dbo schema, and will copy the data in the table across to the new table. You can change these settings as well as the name of the new table in the **Copy Settings** section of the dialog.

![SQLServerTools_CopyTable_CopySettings.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_CopyTable_CopySettings.png)

When you click **OK**, a confirmation dialog appears which summarises the copy action. Click the **Confirm Copy** button.

![SQLServerTools_CopyTable_ConfirmDialog.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/SQLServerTools_CopyTable_ConfirmDialog.png)