View Single Post
 
Old 10-27-2012, 06:46 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Excel VBA & SQL?

Can I just program in Excel with VBA to connect to a SQL database either for fetching or updating data like PHP and MySQL? As I see on the Internet, people're using SSIS, Microsoft SQL Management Server or simply write a VB program to load an Excel file and import data into the SQL server.
Reply With Quote