Updating data from excel to access dating for farmers only
Use ADO if you can choose between ADO and DAO for data import or export.
As you proceed, remember that updating data is not the same process as entering new data.Many Thanks Bill, Welcome to the Lounge as a new poster.Yes, if you use a different name each time you will have to change the file name in the update query. I then need to update the Access data with data that is passed back. I distribute this to some people and ask them to update fields.