A request to see if I don't need to reinvent the wheel ...
We've been using Eventbrite for managing bookings on workshops etc and I've been asked to look at importing that data into our Access contacts database. I can download the booking data from the Eventbrite website in Excel format, and it's no problem just uploading it. But I'd like to minimise manual process and avoid duplicates.
So what I'm looking for is if anyone has any procedures (I couldn't see anything in the Code Repository forum here) that they're willing to share, and that would cover uploading from Excel, checking for duplicates and (this is my feeling as to the way to go), presenting the user with lists of current records and possible duplicates in the new data, so they can accept or reject possible matches.
I appreciate this is a bit cheeky, but I'm sure I'm not the first person to need to do something like this, and even something vaguely similar would be useful to get my thinking on the right lines.
Cheers.
We've been using Eventbrite for managing bookings on workshops etc and I've been asked to look at importing that data into our Access contacts database. I can download the booking data from the Eventbrite website in Excel format, and it's no problem just uploading it. But I'd like to minimise manual process and avoid duplicates.
So what I'm looking for is if anyone has any procedures (I couldn't see anything in the Code Repository forum here) that they're willing to share, and that would cover uploading from Excel, checking for duplicates and (this is my feeling as to the way to go), presenting the user with lists of current records and possible duplicates in the new data, so they can accept or reject possible matches.
I appreciate this is a bit cheeky, but I'm sure I'm not the first person to need to do something like this, and even something vaguely similar would be useful to get my thinking on the right lines.
Cheers.