Link Excel to membership database

Do you have a useful link that involves the Church and the technology discussed on this site? Post your links and resources here.
longc
New Member
Posts: 29
Joined: Tue Jan 01, 2013 12:25 pm
Location: Rupert First Ward

Link Excel to membership database

Postby longc » Sun Jan 05, 2014 7:03 pm

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.

User avatar
aebrown
Community Administrator
Posts: 14685
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Re: Link Excel to membership database

Postby aebrown » Sun Jan 05, 2014 7:19 pm

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.

longc
New Member
Posts: 29
Joined: Tue Jan 01, 2013 12:25 pm
Location: Rupert First Ward

Re: Link Excel to membership database

Postby longc » Sun Jan 05, 2014 7:24 pm

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. :-)

User avatar
aebrown
Community Administrator
Posts: 14685
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Re: Link Excel to membership database

Postby aebrown » Sun Jan 05, 2014 7:26 pm

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.

pgm44
Member
Posts: 86
Joined: Sat Jul 16, 2011 6:19 am
Location: Philippines, Cagayan de Oro city, Northern Mindanao

Re: Link Excel to membership database

Postby pgm44 » Mon Oct 13, 2014 6:58 pm

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.

User avatar
marianomarini
Senior Member
Posts: 594
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy
Contact:

Re: Link Excel to membership database

Postby marianomarini » Wed Oct 15, 2014 2:34 pm

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!


Return to “Links & Resources”

Who is online

Users browsing this forum: No registered users and 1 guest