Results 1 to 6 of 6

Thread: Query Merge error
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2015
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Query Merge error

    Hello,

    I have two queries I'm trying to merge. Both have a Unique Identifier column (Column A, "Client #") and about half of the values on Table 2 are on Table 1. I'm trying a Left Outer join. When I try to merge them, I get the following error:

    DataFormat.Error:
    We couldn't convert to Number.
    Details: (Archival5162016)

    In both queries, I've formatted the 'Client #' column as a Number, so I'm not sure why this occurring.

    Thanks!

  2. #2
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Query Merge error

    Just because you format the column as s number doesn't make the data format a number. Most likely you have some data that is number and some other data that looks like number but it's text. You need to convert them to the same data format.

    Where are you pulling the data from?

  3. #3
    New Member
    Join Date
    Oct 2015
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Query Merge error

    Both queries are from Excel tables.

    There are some values in the column that are not a number (i.e. "A1234"), so I tried converting both columns to text as part of the query as well, but this doesn't solve the issue. The same error pops up.

  4. #4
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Query Merge error

    Have you tried converting the original data in tables to text and then refreshing the query?

  5. #5
    New Member
    Join Date
    Jan 2015
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Query Merge error

    Can we get a solution to this?

    Iím having exact same issue.

    Iíve converted all the Employee IDs in both tables to number format. Still getting error.

    Also tried converting both to text.

  6. #6
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,850
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Query Merge error

    Quote Originally Posted by canefan17 View Post
    Can we get a solution to this?
    post a link to the shared excel file with your problem
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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