Well like I said this would be possible but it would involve some quite a bit of code.
One thing you would need to do would be to automate Excel from Access.
Are you sure that sort of thing wouldn't need to go through some sort of approval process as well? I'm taking the files home with me this evening so maybe I'll have time to work on it at home to see what I can come up with.
Heh, no, the data is owned by the users, but my team owns the database itself, including the actual database update process, so those are internal changes that I won't have problems getting approved within a couple of days. I'm not suggesting you modify them, and manipulate is probably the wrong word for what I actually mean.
How do I use an Excel file to update fields in an Access database?
What I have is a large Access database and I generate an Excel report each week for the users showing the current database content.
The users make updates to the Excel report and send the changes to me. Many times, the updates run into the thousands of cells that either need to be updated, obsoleted, or added as a new record.
Six months from now we just might have a process that we can implement.
I distribute this to some people and ask them to update fields.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
I can do searches on colors, no problem, I've done it before.
I just need to know how to search the workbook from Access and update the correct record and field(s).