Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Union Query from Access (2003)

    I try to get data fom an union query in a access database. Unfortunately, I have an error message saying "to few parameters. Expected 2". I have the same message even if I try to save the query.
    Any suggestion'
    Thanks and regards,
    Marcel

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Union Query from Access (2003)

    Assuming the query runs in Access.
    You could just run the query in Access, select all the data then paste it into Excel.

    Carla

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Union Query from Access (2003)

    Yes, I did this way as it seems that depending on the size or the complexity of a union query, Excel could not import them.
    Thanks anbd regards,
    Marcel

Posting Permissions

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