Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
copying data from one table to another table
August 19, 2010
There will be four tables in database(week1,week2,week3,week4).
i am uploading data from excel to database.Everytime i uplaod data from excel it should be copied to fourth table.
Intially 4 tables will be empty.when i upload first excel file data it should be copied to fourth table.When i select next excel file fourth table data should be copied to 3rd table and new file should be uploaded to fourth table.similarly when i select 3rd excel file it should be inserted to 4th table and 4th table data to 3rd table,3rd table data to 2nd table.
Posted Date: January 30, 2011 Points: 5
You can use the below SQL query to save data from one table to another
Syntax to copy the structure of the one table into another table.
syn: select * into newtablename from oldtablename where false condition
ex: select * into dept1 from dept where 1=9
sytanx to copy one table data into another table.
syn: insert into newtable name select * from old tablename
ex: insert into dept1 select * from dept.
Mark As Answer
" if this post help you.
To post reply
Related Questions Related Questions
Get XML Data in datagridview from SQL SERVER Table
Data is not retrieved from a data table
How to conenct Sql Server and Display Data of a table in WPF Windows Application
How To Insert Data from 1 table to Another Table
Two data table adapter not created
send first table data to another table
send one table data to another table
how to read the xml values into data table.
Trigger fire wrong data to table problem
getting data table from database to datagridview
Latest Forum Questions From The Same Category
Slash(/) in Combobox
attaching the report in the web page
How do i get payment status in redirect page using bitpay?
Login with Facebook and Save details in database
Login with facebook account in my website
How to make a nested datalist control?
What class does Icon derive from?
What are the validation controls?
What''s the difference between an interface and abstract class?
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend