Jump to content

Updating Records


This topic is 3105 days old. Please don't post here. Open a new topic instead.

Recommended Posts

What are the best practices for updating records?

For example, every three months I receive an Excel file containing data (name, event ID, location time, etc.). These Excel files are set up identically, so it makes it easy to import through a script. I use this information to budget, staff and schedule. However, as each new Excel file is sent to me, the previous Excel file is updated with data (such as number of attendees for each event that occurred). I created new fields to accommodate this information and want to 'add' the new information to the existing records automatically (there are several hundred events every three months and I would hate to update manually). What is the best way to re-import just the new data into the fields - and find/match so that the correct attendees data finds/matches the existing event records?

Link to comment
Share on other sites

This topic is 3105 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.