Get EXCEL data using SQL in VBA!

preview_player
Показать описание
There are tons of ways to get the data from Excel worksheet. In this video I’m going to show You how to query Excel data using SQL in VBA.

CODE from video:

PREVIOUS VIDEO:

TIME STAMPS:
0:00 Intro
0:25 Mix SQL & VBA
1:14 Project References
1:33 Sample data
1:50 Exercise
2:12 Function
2:38 SQL string query
3:23 Connection string
3:52 ADODB recordset
4:17 Outcome
5:39 Thank You for watching!

SITE & SOCIALS:

CONTACT:

Don't forget to leave like and subscribe to my channel, it means a lot to me :)
  1. SimpleExcelVBA
  2. how to get excel data using sql in vba
  3. sql query using adodb in vba
  4. query excel file with sql in vba
  5. active x database data object to query data from excel file
  6. sql database solution to get data from excel file
Рекомендации по теме
How to import 0:09:28

How to import data from Microsoft Excel into Microsoft SQL Server

Use Excel to 0:13:51

Use Excel to Connect to SQL Server Data

Run SQL queries 0:07:13

Run SQL queries in EXCEL (just like a normal Excel formula 🤯)

How to export 0:05:49

How to export data from SQL server to Excel | Export table records to Excel | SQL DBA

How to import 0:13:00

How to import data from Microsoft Excel into Microsoft SQL Server

Import data from 0:02:25

Import data from Excel to SQL Server table

How to EASILY 0:10:00

How to EASILY Import data from EXCEL to SQL Server Tables [2024]

How to import 0:03:16

How to import an SQL or an ODBC data source into Excel and PowerBi using PowerQuery

Create Database, Table 0:18:19

Create Database, Table & Insert Data in MySQL

Connect SQL Server 0:07:01

Connect SQL Server from Excel and retrieve data

How to Automate 0:23:52

How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]

How To Edit 0:00:41

How To Edit SQL Server Tables In Excel

Import Excel Tables 0:11:02

Import Excel Tables To SQL Server (Or Any Database) Without A Single Line Of SQL Using Python

Excel Alternative: How 0:09:59

Excel Alternative: How to use SQL to perform EXCEL tasks (SQL for Data Analysis)

MS SQL Server 0:03:40

MS SQL Server - Management Studio - Import excel sheets as tables into database

127 How to 0:08:59

127 How to import all excel files from a folder to SQL server and create table automatically in SSIS

How to use 0:07:10

How to use Native SQL Queries on Excel Data with Power Query

How to Sql 0:04:02

How to Sql Server Read Excel File Using Openrowset 100% No Error

Learn SQL for 0:58:22

Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)

Import / Convert 0:01:31

Import / Convert Excel to sql insert query script

How To Import 0:03:26

How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6

Upload Excel File 0:07:14

Upload Excel File Data To MS SQL Server Using Python (Source Code In Description)

How to Import 0:05:36

How to Import data from Excel to Oracle Database using SQL Developer | SQL Developer Tips and Tricks

How Power Query 0:09:02

How Power Query Will Change the Way You Use Excel

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

Very neat !, also a nice way to get data from excel file without "opening" it.

BackPly
Автор

Hi, that is exactly what I’m looking for, thanks for the video.

I want move my datasets from excel tables (currently) to an sql database. Which sql service provider do you recommend?

I don’t know how to choose one properly, my total database in excel has less than 10mb, with around 20 tables and some of them have more than 50k rows.

Looking the pricing of the sql servers it seems super complex, where I need to chose the processor a lot of other stuff. Any direction to help me in the next steps?

I’m already have a system that works really well in vba, but I need to make it multiuser

brunoamaral