Post reply

export table to access .mdb

  • July 25, 2014 at 2:47 pm

    #289060

    Hi

    When export a table to .mdb it takes about 7 hours, it runs very slow.

    table is aprox 75Mb and 175000 rows.

    When executing the stored procedure to create the table it takes only 3 min.

    SQL 2005

    Server HP G5 ML370

    CPU 2x Intel Xenon

    RAM 4GB

    HDD 250GB SCSI 10000rpm

    Thanks

  • July 25, 2014 at 3:18 pm

    #1732550

    Quick question, how are you exporting it?

    I normally find importing to access faster than exporting to access.

    😎

  • July 26, 2014 at 2:36 am

    #1732580

    select database >task> export....

    select source DB>select target ...>select table ..

  • July 26, 2014 at 3:10 am

    #1732586

    lambrache.theodor (7/26/2014)

    select database >task> export....

    select source DB>select target ...>select table ..

    Had this problem few times in the passed when I needed a dataset from SQL Server in a local Access DB.

    If I exported from SQL Server it was normally 10 times slower than creating an Access DB, opening it and import the data from SQL Server.

    😎

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

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