| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Access queries from Excel
I have an Excel sheet that I want to connect to several different Access
queries. A lot can be done automaticaly with importing data. What I want to do is to add a parameter to the query that is being executed. The VB code looks like this: ..CommandText = Array("SELECT * FROM `C:\PaycheckData`.`3-2CurBMProfile`") I want to add CompanyID (which the user choose in the Excel doc. The Queries have a bunch of " in them so sending the SQL in is hard, and I don't want to do it like that either, because there are gonna be non-programmer users using the document. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open all Excel spreadsheets/fles before running queries | Excel Discussion (Misc queries) | |||
| Access Queries not seen in Excel | Excel Discussion (Misc queries) | |||
| Access Queries into Excel | Excel Worksheet Functions | |||
| Excel Queries using Access data | Excel Discussion (Misc queries) | |||
| Using Excel Worksheets like Access Queries | Links and Linking in Excel | |||
Threaded Mode
