I have a large database that needs editing

[MGM]

I have a bunch of fairly large databases, each going anywhere from 1,000 rows to 50,000 rows. These databases, however, need some editing. They have extra columns that need to be removed and certain other columns that need to be populated. What would be the fastest way in doing this?

I'll also need to add these database to another large database (a "total" database) that contains all of the data. Should I do the edits beforehand on the same database then insert it into the "total" database or should I just do the edits and insert directly into the "total" database on row at a time? Apologies if this sounds confusing...

MGM out

[ck9663]

I have a bunch of fairly large databases, each going anywhere from 1,000 rows to 50,000 rows. These databases, however, need some editing. They have extra columns that need to be removed and certain other columns that need to be populated. What would be the fastest way in doing this?

I'll also need to add these database to another large database (a "total" database) that contains all of the data. Should I do the edits beforehand on the same database then insert it into the "total" database or should I just do the edits and insert directly into the "total" database on row at a time? Apologies if this sounds confusing...

MGM out

try to edit everything on your smaller dataset. if you mess up on the "TOTAL" database, you'll have a bigger problem in your hand..."massage " your smaller datasets, then do a one-time insert to the "TOTAL"...m ake sure to have a way back to revert to your previous state of your "TOTAL", just in case

[MGM]

If I wanted to edit 50,000 rows in one of the smaller datasets before uploading to the TOTAL database, what would be the fastest way of achieving this?

MGM out