http://www.fortochka.com

Export a microsoft access table or query to a html sortable table


 Please donate a small amount if this script was useful for you.
Access database can export tables or a queries to html tables. But these tables are not sortable.

LastName FirstName Title BirthDate HireDate Salary
Davolio Nancy Sales Representative 12/8/1948 5/1/1992 $80000.00
Fuller Andrew Vice President, Sales 2/19/1952 8/14/1992 $120000.00
Leverling Janet Sales Representative 8/30/1963 4/1/1992 $75000.00
Peacock Margaret Sales Representative 9/19/1937 5/3/1993 $85000.00
Buchanan Steven Sales Manager 3/4/1955 10/17/1993 $90000.00
Suyama Michael Sales Representative 7/2/1963 10/17/1993 $70000.00
King Robert Sales Representative 5/29/1960 1/2/1994 $78000.00
Callahan Laura Inside Sales Coordinator 1/9/1958 3/5/1994 $83000.00
Dodsworth Anne Sales Representative 1/27/1966 11/15/1994 $65000.00


Access to sortable HTML exporter can make these tables sortable.
Please click a column header to sort a column.

LastName FirstName Title BirthDate HireDate Salary
Davolio Nancy Sales Representative 12/08/1948 05/01/1992 80000.00
Fuller Andrew Vice President, Sales 02/19/1952 08/14/1992 120000.00
Leverling Janet Sales Representative 01/26/1966 04/01/1992 75000.00
Peacock Margaret Sales Representative 09/19/1937 05/03/1993 85000.00
Buchanan Steven Sales Manager 03/04/1955 10/17/1993 90000.00
Suyama Michael Sales Representative 07/02/1963 10/17/1993 700000.00
King Robert Sales Representative 05/29/1960 01/02/1994 78000.00
Callahan Laura Inside Sales Coordinator 01/09/1958 03/05/1994 83000.00
Dodsworth Anne Sales Representative 01/27/1966 11/15/1994 65000.00


Instructions to use Access to sortable HTML exporter:

  1. Download AccessToSortableHTML.mdb


  2. Open "AccessToSortableHTML.mdb".


  3. Copy a form "AccessToSortableHTML" to any your Access database.


  4. Open a form "AccessToSortableHTML" in a design mode in your database.


  5. In the Visual Basic Window Open Tool>>References


  6. Unselect Microsoft ActiveX Data Object (if selected) and select Microsoft DAO 3.6 Object Library (or later).


  7. Open a form "AccessToSortableHTML" in a running mode.


  8. Select a Table/Query and Press an "Export Table" or "Export Query" button to generate a html file in the database directory with a sortable html table or query.