C curious K New Member Mar 14, 2016 #1 0down vote favorite I want to access/Retrieve/create recordset from SQL SERVER data in excel vba. I tried following methods but it gives an error. __________________________________________________________________ Mod edit : thread moved to appropriate forum !
0down vote favorite I want to access/Retrieve/create recordset from SQL SERVER data in excel vba. I tried following methods but it gives an error. __________________________________________________________________ Mod edit : thread moved to appropriate forum !
Chihiro Excel Ninja Mar 14, 2016 #2 What methods? I'd recommend creating view or query in SQL side and using data connection to bring the data into Excel. Make sure you have the appropriate credentials and database is set to accept external connections.
What methods? I'd recommend creating view or query in SQL side and using data connection to bring the data into Excel. Make sure you have the appropriate credentials and database is set to accept external connections.
