none
Transferring data to external db RRS feed

Answers

  • Hi Y a h y a,

    please visit the link below. in the link you get example of it.

    Access VBA: Export Access tables using ODBC

    the link below will give you information regarding DoCmd.TransferDatabase Method .

    DoCmd.TransferDatabase Method (Access)

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, July 7, 2016 3:01 AM
    Moderator

All replies

  • If it's a linked table, can you not simply use and append query?

    If you truly want to do it in code, then what about using ADO coding?


    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Wednesday, July 6, 2016 1:54 PM
  • Yahya, why do you ask essentially the same question several times, rather than following up on discussions that were already started, such as here: https://social.msdn.microsoft.com/Forums/office/en-US/c718d816-69bf-4be6-ba3c-37668639a58c/running-passthrough-queries-between-two-databases?forum=accessdev#c718d816-69bf-4be6-ba3c-37668639a58c

    What you're doing is considered rude by some people.


    -Tom. Microsoft Access MVP

    Wednesday, July 6, 2016 3:24 PM
  • Hi

    I have done it with an access query as below;

    Const ODBCString As String = "ODBC;DSN=MyDSN;UID=Admin;Trusted_Connection=Yes;DATABASE=MyDB;"
    
    St = "SELECT [MyTable].* " & _
         "INTO " & ODBCString2 & ".[MyTable2] " & _
         "FROM [MyTable]"
    
    CurrentDb.Execute (St)

    Thaks

    Regards

    Wednesday, July 6, 2016 11:00 PM
  • Hi Y a h y a,

    please visit the link below. in the link you get example of it.

    Access VBA: Export Access tables using ODBC

    the link below will give you information regarding DoCmd.TransferDatabase Method .

    DoCmd.TransferDatabase Method (Access)

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, July 7, 2016 3:01 AM
    Moderator