hi
dbconn.Execute "SELECT * into Tab_Add_Ach_qty FROM Add_Ach_qty"

this query will create table "Tab_Add_Ach_qty" and insert the values from "Add_Ach_qty" table automaticlly in ms-access .But in sql server its not happining ? what we should do for corresponding?
help

Do you see any errors? If so how about posting it here.

_________________________
- Vijay G
Strive for Perfection

Your SQL statement is correct. One possible reason why you are not able to create the Tab_Add_Ach_qty table is that you don't have the permission to create objects in the database.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp