Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Israel
    Posts
    10

    Talking Unanswered: Backup SQL Tables

    Good morning

    i have a remote SQL Server tables and a remote Access.mdb file with the same tables in it.
    i need to find a way to transfer the data from the SQL tables to the Access tables, with SQL commands, without being dependent in the SQL enterprise manager.

    does anybody have a good idea?

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb Re: Backup SQL Tables

    Originally posted by Miri
    Good morning

    i have a remote SQL Server tables and a remote Access.mdb file with the same tables in it.
    i need to find a way to transfer the data from the SQL tables to the Access tables, with SQL commands, without being dependent in the SQL enterprise manager.

    does anybody have a good idea?
    You can open a new Access file as a temp file then
    You can use the

    DoCmd.TransferDatabase acImport, "ODBC-Datenbank", _
        "ODBC;DSN=" & your_Dsn & ";UID=" & yourID & ";" & _
        "PWD=" & yourPASSWORD & ";LANGUAGE=us_english;" & _
        "DATABASE=" & YourDB & " ", acTable, YourSourceTable, & _
        YourDistinationTable

    to import your Tables from the SQL through ODBC then

    you can Export them to the other ACCESS DB

    Hope it's clear     

  3. #3
    Join Date
    Oct 2003
    Location
    Israel
    Posts
    10

    Thumbs up Re: Backup SQL Tables

    Thank you, Thank you, Thank you !!!!!
    that's a GREAT idea !

    i'll do that

    have a great day...

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Backup SQL Tables

    Originally posted by Miri
    Thank you, Thank you, Thank you !!!!!
    that's a GREAT idea !

    i'll do that

    have a great day...
    Hope it functions
    Let me know
    Have nice day too

    Shalom
    Salam

  5. #5
    Join Date
    Oct 2003
    Location
    Israel
    Posts
    10

    Thumbs up Re: Backup SQL Tables

    well, i tried it, and it works great !
    you're a life saver.

    Shalom, Salam to you too, and all the best

Posting Permissions

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