Search results

How I solved it, using a workaround. I created a new table using the following query SELECT Lokacija.ID, Lokacija.[ID Inventar], Edm2012.x, Edm2012.y, Edm2012.z, Edm2012.EDM INTO new FROM Lokacija, Edm2012 WHERE Lokacija.Edm_Br=Edm2012.EDM; The query put in the new table the fields that I...

I need to move the data into specific rows, not append them. So in table 2 I already have the foreign key data and edm field filled, now I need to insert the data from table 3 in such a way so that each location field (x,y,z) data from table 3 matches the adequate edm already present in table...

I need to import data from table 3 into table 2 in such way so that locational data (x,y,z fields) of a specific EDM_num in table 2 matches the descriptive data associated with the adequate Inventory_num in table 1 (i.e. EDM_num=Inventory_num)

table 1. Inventar - contains descriptive data fields: ID - primary key Inventory_num Date Sector Spit Description Length Width Diameter Dating Housing Drawing table 2 Lokacija - contains location of the item ID - primary key ID_Inv - foreign key X Y Z EDM_num table 3 EDM2012 - imported Excel...

I have imported the data into a new access table within the database. Afterwards I have tried to use the append query, but when I run it, it always says you're about to import 0 records into table... and I can't seem to find a reason why. the query is as follows INSERT INTO Lokacija ( x, y, z...

Hello, I have a specific problem with a database. It is a rather simple database with only two tables. The first, called the Header contains general info of certain archaeological objects like its dimensions, type, context number and image for instance. The second, called location contains the...

Hello all, my name is Miroslav, but I go ba dzibril also. I deal with archaeological data in RDBMS and am often confronted with badly organised data from various sources that need to be incorporated into databases they were never meant to become a part of. So I will need your help a lot. A...