|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 27th, 2004, 04:34 PM
|
|||
|
|||
Importing Query results to Excel
Hi,
I am running a query and would like the results to populate certain cells in an excel spreadsheet. Is there a way to have a field in my query be sent to a specific column in Excel? Thanks, Chuck 
|
|
#2
May 27th, 2004, 07:14 PM
|
|||
|
|||
|
Importing Query results to Excel
Chuck,
You may want to try designing your query in Access, then in Excel, look at using Data/Import External Data under the main menu. That's one way you can populate spreadsheets. Mark -----Original Message----- Hi, I am running a query and would like the results to populate certain cells in an excel spreadsheet. Is there a way to have a field in my query be sent to a specific column in Excel? Thanks, Chuck .
|
|
#3
May 27th, 2004, 09:29 PM
|
|||
|
|||
|
Importing Query results to Excel
Programmatically, you could create a recordset with just
that one field and use the CopyFromRecordset method? -----Original Message----- Hi, I am running a query and would like the results to populate certain cells in an excel spreadsheet. Is there a way to have a field in my query be sent to a specific column in Excel? Thanks, Chuck .
|
|
#4
May 28th, 2004, 12:46 PM
|
|||
|
|||
|
Importing Query results to Excel
Hi Chuck,
I think this will help: http://support.microsoft.com/?kbid=210288 ACC2000: Using Automation to Transfer Data to Microsoft Excel Good luck, Gary Walter "ChuckW" wrote I am running a query and would like the results to populate certain cells in an excel spreadsheet. Is there a way to have a field in my query be sent to a specific column in Excel?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
