Query Merge error

th3h0bb5

New Member
Joined
Oct 16, 2015
Messages
10
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!
 

chicagocomputerclasses

Well-known Member
Joined
Mar 2, 2015
Messages
645
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?
 

th3h0bb5

New Member
Joined
Oct 16, 2015
Messages
10
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.
 

canefan17

New Member
Joined
Jan 27, 2015
Messages
14
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.
 

Forum statistics

Threads
1,077,614
Messages
5,335,253
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top