Access file data to list box

[domt]

I would like to load data from an Access file yo a VB6 list box, but first the VB program would Sort the Access table. What coding is used to Sort an Access table from VB ?
Thanks for any help

 

[case81]

try this :

sqlStr = "SELECT * FROM table_name"

rsList.cursorlocation = aduseclient

rsList.open dbcon,sqlStr

rsList.sort = "Sort_field ASC"

while rslist.eof = false
list1.additem (rslist.fields("field_name&quot)

wend