Results 1 to 2 of 2

Thread: Sort a Table

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Sort a Table

    I have a table, want to copy it using DoCmd.CopyObject , anyTable & "_COPY", acTable, anyTable

    But I want to be sure that it is sorted to a definite field say [id].

    How could that be done using vb.

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    If the table already indicies, they will be copied over with .CopyObject, if not, you'll need to set them up using ADOX or the Tables Collection (DAO)
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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