/    Sign up×
Community /Pin to ProfileBookmark

Connect to 2 databases with one query.

I have an Access database and an SQL database. I want to create a query that pulls from both based on a job number field. Is this possible? Thanks!

to post a comment

2 Comments(s)

Copy linkTweet thisAlerts:
@TerrorkeOct 09.2007 — I'm not sure if this can be done because you will need two connections to the different databases.

What you can do is you can execute the same query on the two databases
Copy linkTweet thisAlerts:
@nbcrockettauthorOct 09.2007 — I can pull the same query from both databases, but I need them combined into one recordset. I only want to pull the records where all of the job numbers are in both tables. Any suggestions on how to do this with one or two recordsets. Thanks.
×

Success!

Help @nbcrockett spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.19,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...