Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 13th, 2003, 06:57 AM
Authorized User
 
Join Date: Jun 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Script !!

Hi, friends,
as can I do to add data in a table from another table?
Warning! I have already a new table and must only copy a data from another table..:)

Thank you !!!
 
Old June 13th, 2003, 07:03 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes - with an "append query"

You can either write the SQL Insert statement yourself
such as
Code:
INSERT INTO Table1 (Field1, Field2)
SELECT Field1,Field2
FROM Table2;
- or you can get Access to do it for you, by selecting "APPEND" in the query type.

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends
 
Old June 13th, 2003, 07:10 AM
Authorized User
 
Join Date: Jun 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you!!!!1
 I made the error to make too many parentheses...:D





Similar Threads
Thread Thread Starter Forum Replies Last Post
How Run .sql Script file in MS SQL Server 2000? aarkaycee SQL Server 2000 5 October 12th, 2009 05:43 AM
Missing .sql script mzindler19 BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 7 April 19th, 2008 09:27 PM
sql script ttpdotcom BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 March 9th, 2008 03:08 PM
Generate SQL Script shaileshk SQL Server 2000 3 September 6th, 2005 03:12 PM
SQL Script question... dungey PHP Databases 3 January 6th, 2005 11:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.