Post reply

suggestion to copy data from Sql Server into Access database

  • December 22, 2009 at 3:58 am

    #156524

    Situation:

    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 on sql Server have exactlly the same structure of Access database. (the table on Sql Server have 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 want to use VB6 with ado, or naturally other wy are welcome.

    I dont have permission to use Sql Manager and connot write directly in sql server.

    I have only access on sql table via shared permission

  • December 23, 2009 at 3:03 am

    #1095840

    Export the table (*) in a .csv file using the bcp utility (see BOL), copy the file to the NY location and import the data in Access.

    * I understand that you need to export only a table (200.000 rows, 48 columns). I also presume that this is a "one time" job - i.e. you do not need to run it on a scheduled basis.

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

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