Results 1 to 4 of 4

Thread: Table to access

  1. #1
    Join Date
    Sep 2004
    Posts
    281
    Rep Power
    0

    Default Table to access

    Hi , guys! does anyone know of a way/component to get a mssql2000 table into ms access file. ?

    i have a tadoconnection to a mssql2000 table. i want to export it to xls or mdb. i know this can be done if i was uing the jetdriver 4.0.
    Last edited by Artificial_Intelligence; Jun 18, 2006 at 10:51 AM.

  2. #2
    Join Date
    Mar 2003
    Posts
    492
    Rep Power
    0

    Default

    Then use the JET Driver to access the MS Access DB file and troll the SQL2000 table while inserting the field values in MS Acess for every row in the SQL2000 table.

    A while not Table.eof do loop will suffice.

  3. #3
    Join Date
    Sep 2004
    Posts
    281
    Rep Power
    0

    Arrow

    Well I neglected to mention that that the sql table is a dynamically generated one. Meaning the fields will not be the same all the time. However, I see what you are saying, it might mean I have to create an empty access table open it then insert the data. Maybe emptying it after they copy it to a new location. (I need a good book on ole/automation in Delphi)

    Thinking out loud there,,,,,,,,,,,,,,,,,thanks much.

    Rasspect

  4. #4
    Join Date
    Jan 2006
    Posts
    74
    Rep Power
    0

    Default

    Have you tried these components? They may do the trick.

    Component name File format

    TSMExportToXLS MS Excel directly without OLE
    TSMExportToExcel using MS Excel as OLE-server
    TSMExportToAccess use the DAO/MS Jet

Posting Permissions

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