Process:
- I first created a Google from, then linked it with Google Sheets which I linked with Excel which I linked further with SPSS.
- Now i have created a syntax code for importing the excel data, saved it.
- Then i created a batch file to open spss and run the syntax editor code to import the excel data.
- then I created a task in Windows task scheduler to schedule the importing of data everyday.
Problem: When i run the batch file code, it only opens the SPSS syntax editor but does not run it.
Primary objective: To automate the process of real time reponse collection through google forms and eventually real time analysis of data.
P.S: I still havent added the analysis code, just importing data for now
------------------------------
Aryan Gupta
------------------------------