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.
|