Hello , I have an Acces Database and an Excell sheet with different fields about the same people , proceeding of two areas of the same institution.
Now I want to join both files in a new database.
I import to a new Access Database the Excell sheet succesfully.
Now I want to make a query with the name as a related field. (there isn't another field with the same value).
But in the Excell sheet surname and name are in the same field (and so was exported to Access) and in the database surname and name are in different fields ; so there isn't any result in the query.
Can you help me to solve this?
Thank you very much!
Now I want to join both files in a new database.
I import to a new Access Database the Excell sheet succesfully.
Now I want to make a query with the name as a related field. (there isn't another field with the same value).
But in the Excell sheet surname and name are in the same field (and so was exported to Access) and in the database surname and name are in different fields ; so there isn't any result in the query.
Can you help me to solve this?
Thank you very much!