View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SupperDuck SupperDuck is offline
external usenet poster
 
Posts: 44
Default 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,