Excel 2010 VBA Tutorial 93 - ADODB - Connecting to a Spreadsheet

preview_player
Показать описание
  1. YourProgrammingNetwork
  2. Visual Basic For Applications
  3. Microsoft Excel (Software)
  4. ADODB
  5. Active Data Objects
  6. Connect to Excel Spreadsheet
Рекомендации по теме
Excel 2010 VBA 0:11:12

Excel 2010 VBA Tutorial 93 - ADODB - Connecting to a Spreadsheet

Excel 2010 VBA 0:11:12

Excel 2010 VBA Tutorial 93 ADODB Connecting to a Spreadsheet

Excel 2010 VBA 0:10:50

Excel 2010 VBA Tutorial 92 ADODB SQL Multiple Parameters and Data Types

Excel 2010 VBA 0:08:42

Excel 2010 VBA Tutorial 94 - Create a New Workbook

Excel 2010 VBA 0:10:58

Excel 2010 VBA Tutorial 64 - Sendkeys

Excel 2010 VBA 0:04:54

Excel 2010 VBA Tutorial 19 - 3D Arrays

Excel 2010 VBA 0:06:53

Excel 2010 VBA Tutorial 1 Creating a Macro with Visual Basic For Applications

Excel 2010 VBA 0:05:12

Excel 2010 VBA Tutorial 97 - Obtaining data from all spreadsheets in a folder

Excel 2010 VBA 0:07:34

Excel 2010 VBA Tutorial 104 - Referencing Add-In Sheets

Excel 2010 VBA 0:03:20

Excel 2010 VBA Tutorial 108 - Right Click Menu Add-In

Excel 2010 VBA 0:09:36

Excel 2010 VBA Tutorial 91 ADODB SQL Parameters

Excel 2010 VBA 0:05:54

Excel 2010 VBA Tutorial 95 - Open an Existing Workbook

Excel 2010 VBA 0:12:07

Excel 2010 VBA Tutorial 98 Combining Data from Multiple Spreadsheets using ADO

Excel 2010 VBA 0:09:36

Excel 2010 VBA Tutorial 91 - ADODB - SQL Parameters

Excel 2010 VBA 0:04:35

Excel 2010 VBA Tutorial 87 ADODB SQL GROUP BY

Excel 2010 VBA 0:12:16

Excel 2010 VBA Tutorial 71 - ADODB - Database Connections

Excel 2010 VBA 0:06:48

Excel 2010 VBA Tutorial 107 - Add a submenu to the right click menu

Excel 2010 VBA 0:05:02

Excel 2010 VBA Tutorial 100 - Creating your Own Formulas

Excel 2010 VBA 0:03:49

Excel 2010 VBA Tutorial 80 ADODB SQL OR

Excel 2010 VBA 0:10:55

Excel 2010 VBA Tutorial 81 - ADODB - SQL Numeric Parameters

Excel 2010 VBA 0:05:52

Excel 2010 VBA Tutorial 88 ADODB SQL Joins

Excel 2010 VBA 0:07:22

Excel 2010 VBA Tutorial 75 - ADODB - SQL INSERT

Excel 2010 VBA 0:03:19

Excel 2010 VBA Tutorial 85 - ADODB - SQL TOP

Excel 2010 VBA 0:05:21

Excel 2010 VBA Tutorial 4 - Hiding Rows and Columns

Комментарии
Автор

Sir, I know this is an older tutorial but I greatly appreciate it.

paulramasco
Автор

Matt!! Awesome videos man!! thanks a lot!!

chesu
Автор

WOW!
Thanks so much for your prompt reply (to my comment on tutorial #71) and for excellent reference to this awesome tutorial!
I’ve learnt a lot from you and managed to create an ODBC connection to my backend excel database, which is located on my work’s shared directory. All is working well.
The only problem is that I needed to disable the password, because I haven’t figured out how to open ODBC connection to a protected excel file.
Your help would be greatly appreciated!

ShavitTube
Автор

Matt, I use Statistical Packages R and STATA in order to do regression analysis. I know we can do regression analysis in Excel as well, but as you know it is not possible to run regressions with more than 1 independent variables in MS Excel.. If you can build a template especially for Logistic Regression, Probit / Logit Models (they are highly useful in Credit Risk Analysis / FInance Industry) it will be highly appreciated.. Lol please feel free to add any non-linear model in your template.. Thanks for your channel!!! I learned a lot from you..

chesu
Автор

You asked for template ideas. I am working with a 2010 Excel SS that has all our IT Data in it for the Oil Wells we have. I want to connect to it from Google Earth Placemark Description Field. So when one of my IT folks click on the site within Google Earth; it will connect to my SS and return all data for that location. I am really close to having it done (thanks to you) but my spreadsheet returned in Google Earth will not format correctly (it scrolls off the web page). Any ideas or a template I could use?

randyjones