PC Review


Reply
Thread Tools Rate Thread

Importing ODBC data tables - how to import table relationships as

 
 
=?Utf-8?B?Q2xheXRvbg==?=
Guest
Posts: n/a
 
      4th Nov 2004
I am using Access to connect to an external ODBC Relational Database, which
contains many tables and many complex relationships. I need to know if there
is a way to not only import the data tables, but to also import the
relationships between these tables as well. Thank you very much in advace
for your help.
 
Reply With Quote
 
 
 
 
Joe Fallon
Guest
Posts: n/a
 
      7th Nov 2004
No.
There is no built in tool to do this.

It may be possible to write code to read the meta data from the other DB and
then write more code to implement it in Access. Never tried it.
--
Joe Fallon
Access MVP



"Clayton" <Clayton @discussions.microsoft.com> wrote in message
news18AD820-8FF4-46C7-B433-(E-Mail Removed)...
>I am using Access to connect to an external ODBC Relational Database, which
> contains many tables and many complex relationships. I need to know if
> there
> is a way to not only import the data tables, but to also import the
> relationships between these tables as well. Thank you very much in advace
> for your help.



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use macro's or VBA to write table relationships after import table =?Utf-8?B?TVROQ0ZP?= Microsoft Access External Data 2 12th Jul 2011 11:57 PM
Importing Tables/Missing Relationships =?Utf-8?B?RWxlbmE=?= Microsoft Access Queries 1 20th May 2005 12:43 AM
Importing Data into a table that have relationships Guy Verville Microsoft Access External Data 2 27th Aug 2004 03:35 AM
Microsoft.Data.Odbc vs System.Data.odbc Andy Lee Microsoft C# .NET 0 13th Feb 2004 06:36 PM
Importing Data Into Completed DB with Tables and Relationships Microsoft Access External Data 4 20th Oct 2003 03:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:59 AM.