SQL basics, Excel to MS access database - Insert/ update/ delete

Learn how to update / extract MS access database from Excel using VBA macro
Excel to access database
How to connect access database
SQL update statement
SQL insert statement
MS SQL Server
MS SQL queries
MS SQL commands
MS SQL basics
MS SQL full course
MS SQL tutorial
automate import data from excel to access
linking an access database to your excel workbook not only let you importlink tables but also
how to create a access database from an excel spreadsheet
import data from excel to access vba
link excel to access query
how to connect excel to access database using vba
update excel spreadsheet from access database


Dim dbConn As ADODB.Connection, dbRecSet As ADODB.Recordset
Dim sConnString As String, sQuery As String
Dim sDBPath As String

'SQL Select Statement
'sQuery = "SELECT Year1, Gold_Price , Final_Status,Date1 from Test;"

'SQL WHERE Statement
'sQuery = "SELECT Year1, Gold_Price , Final_Status,Date1 from Test WHERE Final_Status = 'Closed'"

'SQL Count Statement
'sQuery = "SELECT COUNT(Year1)from Test WHERE Final_Status = 'Closed'"

'SQL ORDER BY Statement
'sQuery = "SELECT Year1, Gold_Price , Final_Status,Date1 from Test WHERE Final_Status = 'Closed' ORDER BY Date1 asc;"

'SQL INSERT INTO statement
'InDate = Date
' sQuery = "INSERT INTO Test (Year1,Date1) VALUES ('2016','" & InDate & "' );"

'SQL Update Statement
sQuery = "UPDATE Test SET Final_Status = 'Thinash' WHERE Year1 = '2016'"


excel to access database
excel to access database connection
excel to access database converter
excel to access database vba
import excel to access database
export excel to access database