Post reply

help for data transfer from access db

  • November 8, 2005 at 9:52 am

    #110746

    Hello

    i have a vb.net function that read access db and move data to web sql server.

    Now the problem come when i try to move more than 1000 rows, the program

    stop to send data and hang.

    I'm using a simple select * from accessTable and insert into sql table.

    Can anyone send some suggestion?

    thanks

  • November 8, 2005 at 10:26 am

    #602831

    You should do it either:

    a) Via a DTS package (it will connect from access to SS2k and port over the data).  This can be scheduled as well is there is a need to run this frequently, or

    b) Via T-SQL code that queries access DB based on linked server pass-through queries and puts the data into the SS2k database.  You can handle complex logic as well in this piece of code.  Look up linked servers in BOL.

     

  • November 8, 2005 at 10:54 am

    #602845

    the access db is in local lan how can i reach by internet? i can run dts package on web server but how can i find the access db?

    Can i connect to access db having only IP address of the server?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply