Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Unanswered: Please help, this should be simple!

    Hi I'm having real trouble doing something that should be simple, but i just can't think of a way around it.

    I need to copy the content of a query into a table.

    Please help I'm going nuts, I using access 97 I think, standandly I would use a "create table as select *" in something that had proper SQL promote but I can't find that here! Not very experienced access user as you may have guessed!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    SELECT INTO

    Check it out.

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    Teddy can you give me a little more info , I'm a little new to this, Where can I type the SELECT INTO command into! Their doesn't seem to be a SQL prompt!
    Last edited by Nixies; 04-29-04 at 18:46.

  4. #4
    Join Date
    Apr 2004
    Posts
    1
    Change your query to a "make table query"

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


    PHP Code:
      SELECT zz_UK.tbl_join_idzz_UK.tbl_FirstName INTO anyTableName
        FROM zz_UK 
    This will result in a new table called anyTablename containing the two fields you selected form the zz_UK table

Posting Permissions

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