R
Red2003XLT
Heres my setup.
I have an Excel Workbook that receives data from a SqlServer Database thru
an Access DataBase.
Currently, I have eleven(11) Access queries running against the SQL Server
Database. The Excel Workbook has twelve(12 worksheets). One sheet per query
plus a summary sheet.
Heres the problem whenever the worksheet is refreshed. the login is for the
SQL Server database is required eleven(11) different times.
How do I reduce the number of times the login is required?
I've read where I should use a macro, I have zero experience using Macros
and just a smidgen more in using Excel.
Any help?
I have an Excel Workbook that receives data from a SqlServer Database thru
an Access DataBase.
Currently, I have eleven(11) Access queries running against the SQL Server
Database. The Excel Workbook has twelve(12 worksheets). One sheet per query
plus a summary sheet.
Heres the problem whenever the worksheet is refreshed. the login is for the
SQL Server database is required eleven(11) different times.
How do I reduce the number of times the login is required?
I've read where I should use a macro, I have zero experience using Macros
and just a smidgen more in using Excel.
Any help?