Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Query rejects "nz" function in Access Query Vaughan Excel Discussion (Misc queries) 0 May 4th 05 05:20 PM
Export Access Record to Specific Cells in Excel Elecdave Excel Discussion (Misc queries) 0 December 29th 04 04:49 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
Excel Macro Query - Search for specific text in cells of a column Mcneilius Excel Programming 2 August 29th 04 05:12 PM
Can You Query Specific Access Records from Excel? neptune[_2_] Excel Programming 1 May 7th 04 09:07 PM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"