iamnamja
asked on
How to deal with binary data types in access
Hi,
I have two tables in two databases that I have linked with my access database.
Table A - in Database A has a primary id in binary (e.g. 0x0002a000084749a4)
Table B - in Database B has an id table that links table A to B, but the hex is stored as varchar.
When I link the tables into access, Table A's id has data type - binary and doesn't show anything, and Table B's id has data type - text and shows the text string of the hex.
I need a way to compare these two tables, so I need a way to get the two ids to link to eachother. Any way to do this?
Also, if i implicitly do a query:
SELECT *
From A
WHERE A.id = 0x0002a000084749a4
i get results. but i would need to do a comparsion of the two tables:
e.g. I need to look for all securities in both table A and B, or only in A, but not in B
SELECT *
FROM A, B
WHERE A.id = B.id
I have two tables in two databases that I have linked with my access database.
Table A - in Database A has a primary id in binary (e.g. 0x0002a000084749a4)
Table B - in Database B has an id table that links table A to B, but the hex is stored as varchar.
When I link the tables into access, Table A's id has data type - binary and doesn't show anything, and Table B's id has data type - text and shows the text string of the hex.
I need a way to compare these two tables, so I need a way to get the two ids to link to eachother. Any way to do this?
Also, if i implicitly do a query:
SELECT *
From A
WHERE A.id = 0x0002a000084749a4
i get results. but i would need to do a comparsion of the two tables:
e.g. I need to look for all securities in both table A and B, or only in A, but not in B
SELECT *
FROM A, B
WHERE A.id = B.id
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! This works perfeclty
(°v°)