Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2008
    Posts
    3

    Unanswered: HELP, Query from two different databases

    Hello,

    I have two databases. I need to create a query in one of the databases. But, there are some data I need in the second database. I really want to know how I can connect/join two different tables in two different databases using SQL.

    And say the two tables are large so that importing one table to an other database is not possible.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Link the table(s).

  3. #3
    Join Date
    Jun 2008
    Posts
    3
    Yeah, but these two tables are in two different .mdb files. How do I link them? That's where I got stuck.

    Thank you

    Quote Originally Posted by rogue
    Link the table(s).

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you can porgramtically connect to multiple access/jet db's
    you can, as rogue says link a table form a remote db... you 'just' need to specify the location of the new table when linking it
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    In the tables tab of the db window, click new and choose link table or right-click and choose link table.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It REALLY helps when you specify which VERSION of Access you have.

    Manually, File - Get External Data - Link Tables.

    I have no idea how to do this with SQL.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Jun 2008
    Posts
    3
    Thank you guys so much. This is really helpful. Very much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •