Hi everyone:):) How can I run SQL query automatically using Excel macros? Thank you, Jenn
J Jenn1981 Member Apr 3, 2014 #1 Hi everyone How can I run SQL query automatically using Excel macros? Thank you, Jenn
Luke M Excel Ninja Staff member Apr 3, 2014 #2 Either of these should help you get started: http://stackoverflow.com/questions/17656331/using-vba-to-query-a-sql-server-table-in-excel http://www.ozgrid.com/forum/showthread.php?t=163196
Either of these should help you get started: http://stackoverflow.com/questions/17656331/using-vba-to-query-a-sql-server-table-in-excel http://www.ozgrid.com/forum/showthread.php?t=163196