Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What would be the easiest way to import the results from an Access query to
specific cells in a spreadsheet. i.e. reference number from the query to a cell that is labeled as ref no |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
The easiest way is to use Microsoft Query. on the excel toolbar click dataget external datanew database query. you will have to set the access database as a data sorce if it isn't already. you can then select the access query and add the query fields to your data base query. then as the MSQ retrieved the data, set the cell you want upper left corner of the data to be. once set up, you can refresh it by clicking an icon (!) from the extrenal data tool bar. good luck FSt1 "Cyberwolf" wrote: What would be the easiest way to import the results from an Access query to specific cells in a spreadsheet. i.e. reference number from the query to a cell that is labeled as ref no |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Export Access Record to Specific Cells in Excel | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Excel Macro Query - Search for specific text in cells of a column | Excel Programming | |||
Can You Query Specific Access Records from Excel? | Excel Programming |