By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,477 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

How to join MS Access table with Sybase table?

P: 1
I would like to join MS Access table with Sybase table and retrieve some data.
Could you please help me in how to code this in MS Access?
Jan 2 '07 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,

First at all find an ODBC driver for Sybase...

Install it and insure the connection with Sybase!

When it is done choose from File -> Get external data -> Link

ODBC as file type and select ur connection with Sybase!

Select the tables that u want in ur access database!

So u can use Sybase database with Access

If u want to join them...

Go in Queries add the Access and Sybase tables and establish the join btwn the respective fields!

Select the fields that should appear!

Ur query is ready for use!
Jan 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.