Excel VBA Working with Databases
27 videos • 44,695 views • by WiseOwlTutorials
1
Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database
WiseOwlTutorials
Download
2
Excel VBA Introduction Part 31 - ADO (ActiveX Data Objects) Modifying Data with Recordsets
WiseOwlTutorials
Download
3
Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
WiseOwlTutorials
Download
4
Excel VBA Introduction Part 51.2 - Pivot Tables using an Access Database
WiseOwlTutorials
Download
5
Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database
WiseOwlTutorials
Download
6
Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver
WiseOwlTutorials
Download
7
Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets
WiseOwlTutorials
Download
8
Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files
WiseOwlTutorials
Download
9
Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries
WiseOwlTutorials
Download
10
Excel VBA Introduction Part 56.5 - Basic ADO Commands
WiseOwlTutorials
Download
11
Excel VBA Introduction Part 56.6 - ADO Commands and Parameters
WiseOwlTutorials
Download
12
Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO
WiseOwlTutorials
Download
13
Wise Owl Answers - How do I get data from a closed Excel file using VBA?
WiseOwlTutorials
Download
14
Wise Owl Answers - How do I loop through worksheets in a closed workbook?
WiseOwlTutorials
Download
15
Wise Owl Answers - How do I get data from multiple closed Excel files using VBA?
WiseOwlTutorials
Download
16
Wise Owl Answers - How do I loop through sheets in multiple closed Excel files?
WiseOwlTutorials
Download
17
Wise Owl Answers - How do I get data from multiple workbooks with one query in VBA?
WiseOwlTutorials
Download
18
Wise Owl Answers - How do I populate a listbox using an ADO recordset in VBA?
WiseOwlTutorials
Download
19
Wise Owl Answers - How do I get the column names from an ADO recordset?
WiseOwlTutorials
Download
20
Wise Owl Answers - How do I get data from a CSV file using ActiveX Data Objects?
WiseOwlTutorials
Download
21
Wise Owl Answers - How do I add a filename to the results of an ADODB query?
WiseOwlTutorials
Download
22
Wise Owl Answers - How do I populate an array with an ADODB recordset?
WiseOwlTutorials
Download
23
Wise Owl Answers - How do I count the rows in an ADODB recordset?
WiseOwlTutorials
Download
24
Wise Owl Answers - How do I find the data type of a column in an ADODB recordset?
WiseOwlTutorials
Download
25
Wise Owl Answers - How do I refer to a field name with a dot in ADODB?
WiseOwlTutorials
Download
26
Wise Owl Answers - How do I import tab delimited files with ActiveX Data Objects?
WiseOwlTutorials
Download
27
Wise Owl Answers - How do I select more than 255 columns using ADODB with VBA?
WiseOwlTutorials
Download