Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: insert values from a query into a table

    I have a query called Query1
    how do I insert all the values from the query into a table?

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: insert values from a query into a table

    Originally posted by actionant
    I have a query called Query1
    how do I insert all the values from the query into a table?
    Change it to a Create Table Query

  3. #3
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    cool beans

  4. #4
    Join Date
    Mar 2004
    Posts
    118
    Usually you have

    Select * from tablename;

    change that to

    select * into newtable from oldtable;

    you can even select into from an external database by adding:

    select * into newtable [IN database] from oldtable;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •