Joining two tables from two different databases with VB.net, possible? (Access and SQL Server)

Question

Can you perform a join on two tables, one is an Access database and the other is a SQL Server database.

I understand that I could perform a SELECT on each database, and then manually join the results. Is this how I'm going to have to do it?

I'm working in VB.net, using OleDBConnection stuff.

If it's possible (which I'm beginning to doubt), can you please provide sample code?

You can use [`sp_addlinkedserver`](http://msdn.microsoft.com/en-us/library/ms190479.aspx) to create linked servers. Then you can `join` both tables in a Stored-Procedure even if the one is in Access and the other is in SQL-Server. — Tim Schmelter, Jun 05 '12 at 22:22

score 1 · Answer 1 · answered Jan 12 '13 at 01:55

I think you're looking for this. It's for VB.NET 3.0, but could still apply in some variation in higher versions: http://support.microsoft.com/kb/113701

If you're looking for a programmatic way to do it with VB.NET 4.5, using OleDBConnection and datasets: http://msdn.microsoft.com/en-us/library/bh8kx08z.aspx

score 0 · Accepted Answer · edited May 23 '17 at 11:49

0

You could try using Linq to SQL with 2 different data contexts - see this for an example

edited May 23 '17 at 11:49

Community

answered Jun 06 '12 at 07:18

Ando

2 Answers2