Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Can I use ado SQL within Excel 2003 VBA to reference worksheets (tables) in two different workbooks in the same query?

Posted on 2010-09-15
1
Medium Priority
?
696 Views
Last Modified: 2012-05-10
I am very used to using the JET DB engine in VBA with ADODB to query worksheets using SQL in Excel 2003.  However, the query always referenced sheets in one workbook at a time.  Is it possible to open two connections to two different workbooks and perform a join between two sheets in the different workbooks?  If so, how would I qualify the reference in the SQL query?
0
Comment
Question by:VBAGuy
1 Comment
 
LVL 11

Accepted Solution

by:
jkpieterse earned 2000 total points
ID: 33689145
I doubt if you can do that, but maybe this discussion gives you some pointers:

http://www.vbaexpress.com/forum/showthread.php?t=26862
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question