Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    stupid qstion to ordering filed sin table (2000 sr 1)

    I use a VBA for Excel macro, to insert value from sheet to table into a mdb file...
    is possible to ordering in alphabetical mode the fileds with a mcaro...?

    have in table
    aaa
    cccc
    bbb

    i want in table
    aaa
    bbb
    ccc

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: stupid qstion to ordering filed sin table (2000 sr 1)

    Why do you care about the order in the .mdb table? Whenever accessing that data you can specify a sort order for it, either by specifying an ORDER BY in the query that returns the recordset from the table, or dumping the whole table (in its existing order) into Excel and then sorting it in the s/sheet.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: stupid qstion to ordering filed sin table (2000 sr 1)

    In the future, please ask Access questions in the Access forum.

    (I agree with Dean, the order of fields in a table is irrelevant.)

Posting Permissions

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