# Select data into a new table in another SQL Server **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [May 19, 2020, 1:53am UTC](https://forums.toadworld.com/t/select-data-into-a-new-table-in-another-sql-server/49864 "2020-05-19T01:53:17Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![bermanmf](https://avatars.discourse-cdn.com/v4/letter/b/ba9def/32.png) [@bermanmf](https://forums.toadworld.com/u/bermanmf)\ **Post date:** [May 19, 2020, 1:53am UTC](https://forums.toadworld.com/t/select-data-into-a-new-table-in-another-sql-server/49864/1 "2020-05-19T01:53:17Z")
In a typical select into query, your data go into a new table that is created on the fly. My query brings together data from 3 tables in SQL Server 1, and I want to select it into a new table created on SQL Server 2. I am using a Build, cross-connection window. The first thing I noticed is that the options in the statement type drop-down are grayed out. You can't have Build set up a select into new table for you. When I put the SQL into a cross-connection Editor I get a red x error on the line defining the new table database-conn.database.schema.new-table-name, even if I include an alias for the new table. If I remove the line pushing the data into a new table, the query works. create table connect-string1.dbase.schema.new-table as select Col1, Col2 from connect-string2.dbase2.schema2.new-table also does not work Shouldn't you be able to select into a table in another SQL Server database? Thanks in advance. ---
**Author:** ![bermanmf](https://avatars.discourse-cdn.com/v4/letter/b/ba9def/32.png) [@bermanmf](https://forums.toadworld.com/u/bermanmf)\ **Post date:** [May 19, 2020, 2:40am UTC](https://forums.toadworld.com/t/select-data-into-a-new-table-in-another-sql-server/49864/2 "2020-05-19T02:40:57Z")
Apparently you need to use the Import Export wizard. There must be intermediate steps that the Wizard takes care of.