# I only have microsoft office, how can i write code to manipulate relational data sets?

At work, I am in a role that does not have a lot of computer permissions. I do have the Microsoft office suite. I have skills with programming and would like to be able to use my experience to do more streamlined and substantial manipulation of large relational data sets. Considering I can't get python or even Bash, is there any good way to do this?

• If you have Excel, you have access to write VBA scripts – Jon Feb 2 '18 at 0:05
• You can write SQL in Access – David Marx Feb 2 '18 at 0:11
• Have you tried power query using the data model in Excel – grldsndrs Feb 2 '18 at 7:44

It should be possible to install Python without admin privileges. This has been discussed on Stackoverflow here.

The easiest method appears to be installing Anaconda.

And according to this answer you should also be able to use WSL without admin rights, which will get you bash.

For handling relational data you can use sqlite, which is built-in to Python. For example:

import sqlite3

conn = sqlite3.connect('example.db')
cur = conn.cursor()
cur.execute('''CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT''')
conn.commit()
conn.close()