Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004

    Question Unanswered: Sending data from a query to a table in this possible???

    heey everyone,

    I need some help sorting out data. I have 1 query returning 100+ results and i need to split that query up and save it into 2 access tables. how can i go about doing this?

    I have 2 ideas..neither of which i know how to implement exactly ( thats where i need your help, unless you can think of a better way to do this...)

    1) create a auto numbered main table put the results of the query in that table. have 2 other tables where the first takes 1-85, and the second takes 86-120 directly from a main table


    2)have the SQL statement send the data to the 2 tables using somthing like INSERT somehow..

    If anyone can help me out Id highly appreciate it.


  2. #2
    Join Date
    Oct 2003

    Thumbs up

    Are the structure of the two tables same? Then try the following
    Select top 100 from the table and insert them into the first table
    Select rest of the records from the table and insert them into the second table


  3. #3
    Join Date
    Jun 2004
    SELECT TOP 100
    INSERT INTO table name

    is this what you mean ? its not quite working for me, im putting that after the statement which fetches my 100+ results

  4. #4
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    Select top 100 * Into newTable1 from oldTable where key NOT IN (select top 50 key from oldTable)
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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