I am currently working on a Excel Tool that inserts data from Excel to an Access Database via a SQL Query in EXCEL/VBA.
The code works on my home PC, however at work i don't have access to the ADO Object becuase i don't have developer rights and am not a developer, are there any other methods that can be used to insert data from excel to Access via SQL apart from the ADO Control and will work if you are a normal Excel user(i.e DAO, OLEDB and/or ODBC)
Can somone please help me asap and provide a solution, help will be much appreciated, and i am more than happy to share my experiences/skills in return of this favour.
P.s i am using Excel 2000
Thanks very much
The code that works with ADO.. (the Access db is just a flat file with 2 fields)
Private Sub CommandButton1_Click()
Dim strSQLCommand1 As String
Dim strCnn As String
Dim cnn1 As ADODB.Connection
Dim var1 As String
Dim var2 As String