User Profile

Collapse

Profile Sidebar

Collapse
davec4
davec4
Last Activity: Oct 29 '08, 09:05 PM
Joined: Oct 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • davec4
    replied to Concatenating many tables
    in Access
    A table containing the names of the files to be appended.


    In a generic sense I want to do the following:

    select *
    from TableA

    do name="TableB"," TableD",......" TableX"
    union select *
    from name;
    end;

    Hope that makes it simpler.

    Thanks...
    See more | Go to post

      Leave a comment:

    • davec4
      replied to Concatenating many tables
      in Access
      I want to export the table as an Excel spreadsheet. I can generate the list of tables in a driver table....
      See more | Go to post

        Leave a comment:

      • davec4
        started a topic Concatenating many tables
        in Access

        Concatenating many tables

        I am a new Access use and need to concatenate (UNION) many tables. I am currently doing it "by hand":

        SELECT *
        FROM [TestA]


        UNION SELECT * FROM [TestB];
        UNION SELECT * FROM [TestD];
        .....
        UNION SELECT * FROM [TestX];

        I would like to do this with a loop where I can specify TestA, TestB, .... TestX.
        The table names are abitrary, not Table1, Table2.......
        See more | Go to post
        No activity results to display
        Show More
        Working...