Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    74

    Unanswered: export data to excel

    hi,

    i wanted to do an export of data in my tables to an excel document.
    i managed to export data from ONE table. however i need data form my 2nd table to be exported to my excel. how can i do that?? how can i export data from 2 or more tables to an excel file???

    i have tried exporting data from queries instead of tables but it wont work.

    pls advice
    nono
    Last edited by damnnono_86; 12-02-03 at 04:34.

  2. #2
    Join Date
    Nov 2003
    Posts
    24
    Export the 2nd table the same way you did the first, but call it something different. Then simply copy and paste together.

    hope this helps

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

    Re: export data to excel

    Originally posted by damnnono_86
    hi,

    i wanted to do an export of data in my tables to an excel document.
    i managed to export data from ONE table. however i need data form my 2nd table to be exported to my excel. how can i do that?? how can i export data from 2 or more tables to an excel file???

    i have tried exporting data from queries instead of tables but it wont work.

    pls advice
    nono

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

    Re: export data to excel

    Originally posted by damnnono_86
    hi,

    i wanted to do an export of data in my tables to an excel document.
    i managed to export data from ONE table. however i need data form my 2nd table to be exported to my excel. how can i do that?? how can i export data from 2 or more tables to an excel file???

    i have tried exporting data from queries instead of tables but it wont work.

    pls advice
    nono
    Sorry for the empty message

    If the exported fields are the same or not then
       You can make a creating table Query say [TempEXP]
       query to insert yor
       desired fields from the first table
       also make an Insert query for the secound tabel
       to insert the desired fields in the same table [TempEXP]
    end if

  5. #5
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244

    Re: export data to excel

    Please see our series of articles called "Pumping Data" at http://www.elmhurstsolutions.com

    It outlines how to export multiple tables or queries to separate sheets in an Excel file. You'll need an understanding of VBA, as it's a code-based solution.

    I hope you will find it useful!!



    Originally posted by damnnono_86
    hi,

    i wanted to do an export of data in my tables to an excel document.
    i managed to export data from ONE table. however i need data form my 2nd table to be exported to my excel. how can i do that?? how can i export data from 2 or more tables to an excel file???

    i have tried exporting data from queries instead of tables but it wont work.

    pls advice
    nono
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

  6. #6
    Join Date
    Nov 2003
    Posts
    74

    Talking

    yup, this example is a good one.

    thanks
    nono

Posting Permissions

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