I am new here and quit new to access.
Hope my englisch is well enough to explain the "problem".
I have a non relational database with several lists (tables)
People make reservations for new tagnumbers (equipment, instruments).
At the end of the project they export those records to an excelfile to fill in the extra info.
I made a query for that to filter their numbers using a field with a projectnumber.
I then import the list and all fields containing the correct data.
Not all fields must be filled in, some are there just not to loose old data but are not used anymore.
Therefor i sorted the fields in the query in a different way, they just need to fill in the first xx fields in every record.
Names of the columns did not change.
BUT now i can't import the data anymore since the order is different.
is there a way that acces looks at the columnnames in stead of the order for import?