Results 1 to 3 of 3
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Export table using third Database


    Here is my situation. I have a back end database and a front end. We will call them DBFront and DBBack. I have two more databases (Front end and back end) called DBUserFront and DBUserBack. What I want to do is use DBFront to export tables from DBBack to DBUserBack. I know how to do a straight export if the tables were in DBFront, but they are not. Any help will be much appreciated.

    The reason I don't want to just link DBUserBack to DBBack is because I need to be able to do maintenance to DBBack during the day.

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    I doubt there's any way to handle a "Remote" import/export. Most likely what you'll need to do is import the table from DBBack to DBFront. Then you can export it back out from DBFront to DBUserBack.

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Ok, thank you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Polishing table for export
    By Scaffold in forum Access
    Replies: 6
    Last Post: 07-19-2010, 09:53 AM
  2. Need Helpto Export Access Table to .txt type SDF
    By Kishwar in forum Import/Export Data
    Replies: 2
    Last Post: 05-17-2010, 10:07 AM
  3. Replies: 6
    Last Post: 05-11-2010, 02:22 PM
  4. export table to multiple sheets
    By TheShabz in forum Import/Export Data
    Replies: 5
    Last Post: 04-06-2010, 02:59 PM
  5. Form fields export to local table
    By lupis in forum Forms
    Replies: 0
    Last Post: 03-23-2010, 02:38 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums