Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2012, 06:46 AM
tinfanide tinfanide is offline Excel VBA & SQL? Windows 7 64bit Excel VBA & SQL? Office 2010 32bit
Expert
Excel VBA & SQL?
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA & SQL? Excel 2011 can't open old Excel 98 or Excel X files FLJohnson Excel 8 05-09-2012 11:26 PM
Excel 2007 custom ribbon not showing in Excel 2010 Paulzak Excel 2 02-17-2012 06:35 PM
Excel VBA & SQL? saving data in excel 2010 from excel 2003 johnkcalg Excel 1 02-06-2012 07:33 PM
Excel VBA & SQL? VBA code from Excel 2007 in Excel 2010 csam63 Excel Programming 1 10-07-2011 10:46 AM
Excel VBA & SQL? Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft