Run an Access Query from Excel VBA with Parameters
Dear all,
I have got an access file (L:\YPITHALAT\IKMALImportDATABASE.mdb)
And a query named: qryRapor01-Son
The column names a
1. Analist
2. CD_Supplier
3. CS
Well, to be an easy example, i just want to run the query and get these 3
columns in the excel sheet (for example the first value to cell a1).
My parameter would be like "where Analist is "MK" (OR MK is going to be a
variable)
The problem is i do not know how to make this.
Could you please help?
regards,
|