Access query to specific cells
 

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

Access query to specific cells
 

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