Tech Forum Archive

Link Excel to membership database

6 postsstarted by longc 12,734 viewsoriginal topic

longc
New Member
#1
Are we allowed to link excel to the membership database??

I would like to have a live sheet that would update as the membership clerk makes changes in MLS.
aebrown
Community Administrator
#2
longc wrote:Are we allowed to link excel to the membership database??

I would like to have a live sheet that would update as the membership clerk makes changes in MLS.
Even if it were allowed (which I doubt it would be), there is no way to do what you suggest.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
longc
New Member
#3
All I would need is a read only account name for the database. Then, yes, there is a way. :-)

I use Excel and SQL a lot to do things just like that. It would be MOST handy. :-)
aebrown
Community Administrator
#4
longc wrote:All I would need is a read only account name for the database. Then, yes, there is a way. :-)

I use Excel and SQL a lot to do things just like that. It would be MOST handy. :-)
Well, I wasn't saying that no such technology could exist. I was only saying that it can't be done now with the membership database. There's no way you will get any kind of access to the Church's membership database granted to you for this or any other purpose. The Church is very concerned about the security of its databases.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
pgm44
Member
#5
I have a database in excel with all the member-names and record numbers. Sometimes we have on a donation form only a number and via the database in excel its easy to find the member name.
marianomarini
Senior Member
#6
aebrown wrote:The Church is very concerned about the security of its databases.
You can export MLS data as CVS file but you MUST ensure that that data are kept confidential. Usualy through encryption!
La vita è una lezione interminabile di umiltà (Anonimo).
Life is a endless lesson of humility (Anonimous).