+ Reply to Thread
Results 1 to 4 of 4

Thread: suggestion to copy data from Sql Server into Access database

  1. #1
    Newbie sal21 is an unknown quantity at this point
    Join Date
    Jun 2009
    Posts
    3

    suggestion to copy data from Sql Server into Access database

    Scenario:
    I have a Sql Server in Rome and a shared server dir (with the access database) on a Server in New York.

    I have permission on sever dir and databse.

    The database table on sql Server have exactlly the same structure of Access table. (in the table on Sql Server are 200.000 records and 48 columns).


    Now i want to recopy all records from Rome to NewYork.

    Wath is the best way in terms of time to recopy records

    note:
    I use in my app the ADO drive.

  2. #2
    Newbie sal21 is an unknown quantity at this point
    Join Date
    Jun 2009
    Posts
    3

    Re: suggestion to copy data from Sql Server into Access database

    sorry for up!:-)

  3. #3
    Moderator Orjan is a glorious beacon of light Orjan is a glorious beacon of light Orjan is a glorious beacon of light Orjan is a glorious beacon of light Orjan is a glorious beacon of light Orjan's Avatar
    Join Date
    Sep 2007
    Location
    Karlstad, Sweden
    Age
    34
    Posts
    2,613
    Blog Entries
    7

    Re: suggestion to copy data from Sql Server into Access database

    is this a one time thing, or will it need updating?

    for a one time thing, I'd import it through access built in system via odbc.
    well, you can actually link the sql server table into access directly if you like.
    __________________________________________
    Ask me: Orjan | Contribute to the Wiki! | Make your own Programming blog!
    I usually play eRepublik and Travian when I'm not on CodeCall

  4. #4
    Learning Programmer rabihtawil is on a distinguished road rabihtawil's Avatar
    Join Date
    Sep 2009
    Location
    Oregon
    Age
    23
    Posts
    60

    Re: suggestion to copy data from Sql Server into Access database

    This is rather easy & can be done if you follow the steps i did in this video

    [YOUTUBE]_ih1eqEtt44[/YOUTUBE]
    My Portfolio | My Blog | My YouTube | My Community

    Share your Knowledge, It's one way to achieve immortality.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Detect Character Set
    By dargueta in forum General Programming
    Replies: 14
    Last Post: 09-10-2009, 04:55 PM
  2. Server Security
    By kresh7 in forum Security Tutorials
    Replies: 0
    Last Post: 10-09-2008, 06:25 PM
  3. OOP DB Access Wrapper
    By digioz in forum C# Programming
    Replies: 6
    Last Post: 09-07-2008, 12:58 PM
  4. Setting up server 2003
    By morefood2001 in forum Tutorials
    Replies: 4
    Last Post: 08-18-2008, 10:11 AM
  5. Best program for SQL database manipulation
    By Rhadamanthys in forum Database & Database Programming
    Replies: 3
    Last Post: 07-02-2007, 02:32 PM

Bookmarks

Bookmarks

     
        Algorithms and Data Structures

        Java tutorials

        Algorithms Forum

Posting Permissions

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