<div>
do you want to import from one server to another or in same server one database to another?<br />
<br />
You can do something like this:<br />
<br />
drop table db1.table1<br />
GO<br />
<br />
select * into db1.table1 from db2.table1 <br />
<br />
it will create table1 in db1 and import all records from table1 of db2 to db1.table1<br />

</div>


do you want to import from one server to another or in same server one database to another?

You can do something like this:

drop table db1.table1
GO

select * into db1.table1 from db2.table1

it will create table1 in db1 and import all records from table1 of db2 to db1.table1


<div>
<br />
Its from the same server but a different database, the problem is there are over 60 tables, just thought there might be a way around it.<br />

</div>



Its from the same server but a different database, the problem is there are over 60 tables, just thought there might be a way around it.


1.JPG

<div>
Agree with reza_rad on this...You can select the option of 'Drop and Recreate destination table' if you want to have a fresh table.
</div>


Agree with reza_rad on this...You can select the option of 'Drop and Recreate destination table' if you want to have a fresh table.

<div>
Ritesh answer will have the problem if there is some relationship then drop will affect, but what reza has given will solve the problem for what ur looking for.
</div>


Ritesh answer will have the problem if there is some relationship then drop will affect, but what reza has given will solve the problem for what ur looking for.

<div>
Thanks for your help once again guys.<br />
<br />
reza was spot on, i am not bothered about the relationships, so thanks for pointing that out.<br />
<br />
thanks.
</div>


Thanks for your help once again guys.

reza was spot on, i am not bothered about the relationships, so thanks for pointing that out.

thanks.

<div>
<div class="content wysiwyg-content">
I want to import tables from one row to another but i want to overwire the existing table with the new table, but it looks like the wizard only appends to the existing table.<br />
<br />
Is there any way to drop the table first then inport the tables.
</div>
</div>


I want to import tables from one row to another but i want to overwire the existing table with the new table, but it looks like the wizard only appends to the existing table.

Is there any way to drop the table first then inport the tables.

SQL Import Wizard

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.