Good trick. I'll offer an additional piece. Although if the records are exported from the same set in the same order you should have no trouble, I am always afraid of getting the rows mixed up and getting the wrong info on a person's record. To avoid that, you could export a common field, record number for example, with each set of data. When you paste them together it would be easy to compare these fields and insure the data is consistent.
>Yesterday I needed to export some data for a fundraising consultant we >are working with. She wanted all kinds of info on our donors that >doesn't seem to be covered by a single report, and wanted them all on >one sheet (so not the individual giving history reports). I was trying >to export to an Excel information such as YTD donations, activist >issues, lifetime contributions, etc. along with contact info. ebase kept >freezing up, although I don't know if this has more to do with the >amount and type of things I was trying to export or just my computer in >general. To get past this, I did a couple of exports and combined them. >i.e. I exported the contact info for labels, then did a separate export >of activist issues, another for lifetime contributions, etc then pasted >those columns into the original excel. I thought this might be helpful >if other folks ever have the same problem. :) >-rrw > > >------------------ >Reminder to each recipient: To change your list account preferences, go to >http://email.sparklist.com/scripts/lyris.pl?enter=support and enter >the email address you used to subscribe to the ebase support list:: >[EMAIL PROTECTED] > >To unsubscribe send a blank email to [EMAIL PROTECTED] >--------------------------------------------------------------------- > ebase - Relationship Management for Nonprofits, http://www.ebase.org >--------------------------------------------------------------------- -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
