Results 1 to 4 of 4
  1. #1
    wcrimi is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    142

    Import Data from Database into Same Table Name in another Database

    I have 2 databases. Let's call them A and B

    Let say I have Table X in database A and Table X in database B.

    I want to directly import the data from Database A/Table X into Database B/Table X.



    How can I do it?

    When I try to do it, it creates a new table X 1.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    A typical scenario would be to have a third Access file manage the manipulation of the data. In other words, Data is usually stored, centrally, in the Backend where multiple frontends access and understand the Persistent data that is the Backend.

    So, my first question is relative to the topology you are employing. Do you have a setup where you have split databases? I ask this because the answer to your question, how can I do it, is to build a query. I suppose there is more to it than, building a query.

  3. #3
    wcrimi is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    142
    This is related to another issue we spoke about regarding running out of space in my primary database.

    What I've done is taken my "monster" table and created a new database with it. That has effectively split the data between 2 databases. Now I an experimenting with the best way to communicate between the two.

    I could bring some selected data over and it would be called X1. Then I could write an append from X1 to X. I was just wondering is there was a simpler way.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by wcrimi View Post
    ... That has effectively split the data between 2 databases. Now I an experimenting with the best way to communicate between the two...
    Thank you for reminding me about the other thread. As for having two databases, that is fine. However, I am still not understanding if each of these two databases contain persistent data. So, you can have multiple backends. Each backend will store data that is unique, specific to the database. This data will be available to others as the authoritative data because it persists in its respective database.

    If I am to understand the situation you created, you have two backend files and you want to have them somehow synchronize with each other. If this is the case, I will refer back to normalization of data. Two backend databases should not synchronize. They might replicate. Replication is different.

    Synchronization is akin to data validation. An autonomous front end might desire a snapshot of data. When it grabs a snapshot, it process the data autonomously. Other Users/FE's do not understand what is going on with this snapshot. As time ticks by, the snapshot becomes stale. The authoritative/persistent data is still on the backend. Other users look to the backend for the latest and greatest. After the user is done with its snapshot, it synchronizes with the persistent data, using various methods of data validation. Now I am back to using queries (other tools too).

    I think you might want to consider and separate out FE files from the persistent data.

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

Similar Threads

  1. Import data from one database to another
    By blueman83 in forum Access
    Replies: 1
    Last Post: 09-01-2015, 09:01 AM
  2. Replies: 2
    Last Post: 06-25-2015, 03:56 PM
  3. Import data from one Access database to another
    By wvinton in forum Import/Export Data
    Replies: 4
    Last Post: 10-17-2014, 09:21 PM
  4. Replies: 2
    Last Post: 04-28-2014, 01:38 PM
  5. how to import data into a split database
    By akshatagarwal93 in forum Database Design
    Replies: 3
    Last Post: 08-09-2012, 02:06 AM

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