LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default VB code to run a Query in Access and paste results onto an Excelworksheet

I want to create an application where the user makes a selection from
a 'drop-down' in Excel that triggers a Query in Access, copies the
result of the query and pastes it onto a sheet-tab in the Excel
Workbook.

Is this possible?

If so can anyone help me understand the code I would use?

We are XP using Ecel 2003 and Access 2003

Thank you,

Tony
 
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
No Results returned from Access query Chuck W[_2_] Excel Discussion (Misc queries) 3 September 23rd 09 03:37 PM
Access query not returning results rjchristensen Excel Programming 0 October 22nd 07 04:52 PM
Why are access query results different in Excel DannyD Excel Discussion (Misc queries) 0 July 29th 07 04:54 AM
Access query results to Excel piano banger Excel Discussion (Misc queries) 4 December 8th 06 09:32 AM
VBA - query an Access table - results in Excel rirus Excel Programming 3 August 21st 06 07:29 PM


All times are GMT +1. The time now is 07:20 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"