| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Query Parameters | Excel Discussion (Misc queries) | |||
| Passing parameters from excel to access | Excel Programming | |||
| Is there a way to pass parameters to a web query in excel | Excel Programming | |||
| Web query with parameters does not work in Excel 2000 - Please help | Excel Programming | |||
| RP - Office 2000 automation parameters Access and excel | Excel Programming | |||
Threaded Mode
