Hi all,
Situation
I have a spreadsheet that pulls back multiple tables from Teradata using the Data connection tool within Excel 2010.
Issue
My issue is Excel is requesting me to type my Teradata password in for every table/query bought back/that runs (username is saved).
Question
Is there a way that means I only have to type in my Teradata password once. Then run multiple queries pulling tables back into multiple sheets.
Not used connections much before and cannot find much about them. Preferably don't really want to get into VBA for this.
I know you can have your password saved in automatically but this is not ideal as the report will be distributed.
If anyone can point me to some resources or respond I would appreciate it very much. I had a quick search on these forums to see if I could find any similar threads.
Many thanks
Rob
Situation
I have a spreadsheet that pulls back multiple tables from Teradata using the Data connection tool within Excel 2010.
Issue
My issue is Excel is requesting me to type my Teradata password in for every table/query bought back/that runs (username is saved).
Question
Is there a way that means I only have to type in my Teradata password once. Then run multiple queries pulling tables back into multiple sheets.
Not used connections much before and cannot find much about them. Preferably don't really want to get into VBA for this.
I know you can have your password saved in automatically but this is not ideal as the report will be distributed.
If anyone can point me to some resources or respond I would appreciate it very much. I had a quick search on these forums to see if I could find any similar threads.
Many thanks
Rob