Search results for query: *

Hey Dave, once again sorry for the delayed answers. I can't deal with this topic as constantly as I want to ... Since the statement are quite long and it looks like you are the only one willing to help - can I send it to the mail address given on the site of your company? Regards Axel

Hey, thanks for the replay - sorry for the delay of my answer [can't constantly work on this topic ..] I have been able to get access to an oracle table in excel. But changes that i make in excel are not transferred to access. Even by clicking on 'refresh data' the new entries do disappear. So...

Hey, is there a way to gain access to an oracle table via MS Access/Excel with the right to modify the table? Regards Axel

OK. to match my alb data to the alk data I -deleted the special characters by replacing them with '' -altered the datatype of the alb -removed spaces in alb so that the length is equal to the length of the alk So the datatype is the same, the length is the same and the data 'looks' the same...

Hey willif, Hey Karluk, thanks for your efforts. @ willif: although I am not sure if there is a difference between removing spaces by trim() or replace() I did as you suggested. But I did not have any success. @Karluk: My query to join the two table won't include an special parcel_id - just...

Have been offline for a while - so sorry for the delay. @karluk: yes, that's what I'm saying - except that I have to query without the ''. Could this be for any relevance? @blom0344: to trim I used the command as follows: update ALB_ADMIN.ALPHA_FLST_T set FLURSTUECK_KENNZ = trim(' ' from...

Hey karluk, thank you for this hint. I checked the length() of 'parcel_id' in ALK and ALB: in ALK:19 in ALB:23 So I trimmed the parcel_id in the ALB and checked again: the length has been reduced to 19. But although the characters and the lenght are now the same there is still no join...

Hey, I work with spatial data in an Oracle 9i database in a German municipality and have a problem as follows: I have to join data from the land parcels [ALK] with the corresponding data of the owner of the parcels [ALB]. I will do this with the 'parcel_id' that is differently distinct: ALK...